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...