conditionally formating one cell based of the condition of another?

[slaters]

I have two cells B8 and B9.

B8 Simply states the phraseLast Flight
B9 is a formula that gives a date referencing other cells as long as data was input on that specific date

B9 is conditionally formated so that it turns yellow if the last flight was between 53 and 59 days ago (as a warning)
B9 is also formated so that it turns red when the last flight is 60 or more days ago.

I would like the text in B8 to mirror B9's formating. For some reason I have been screwing up formating and it should be as easy as referencing the same columns... currently I have the following in B8 and B9 (but only B9 changes color)

Yellow if cell value is between =$C$9-53 and =$C$9-59
Red if cell value is less than =$C$9-60

FYI C9=TODAY()

Thanks for any help, one day I will get this down...

[Pete_UK]

That will work for B9 as its cell value can be compared to TODAY. However, the value in B8 cannot. You need to change the conditional formatting so that it uses a formula (at the bottom of the list), and the formula in both cells should be:

=$B$9 < $C$9-60

for red, and:

=AND($B$9<=$C$9-53,$B$9>=$C$9-59)

for yellow.

Hope this helps.

Pete

[slaters]

sure does! quick last question, any way to format the tab color to follow the same formating?

[Pete_UK]

Conditional formatting only works on cells. You have to colour the tabs manually.

Hope this helps.

Pete

[slaters]

bummer, thanks again for helping!