Conditional Formats

  • Thread starter Thread starter ned
  • Start date Start date
N

ned

Hi
I have a row of dates, one week apart and I use the conditional format to
highlight the current week. I would like to highlight the column 12 cells
below the current date which contain text . I tried numerous things ,but my
knowledge is limited.
Is it possible to do?
Thankyou.
 
Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve
 
sorry , I didn't explain it right.
I want to highlight the 12 cells below the highlighted current date. these
cells contain text, so I haven't got a date to conditinally format.

Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve
 
That's the point.

You can't apply conditional formating to one cell to affect a different
one.

BUT you can use a different cell when setting up the conditional format
for a cell

So A1 = last week, b1 = this week, c2 = next week

In B13 set up Conditional Format
=IF(b1=this week,1,0)
And set the format accordingly

Steve
 
Back
Top