Hello,

I'm wondering if it's possible to change the font colour of a range of cells
depending on whether a different range of cells contain red text?

For example cells U1:IU1 contain dates which turn the text red when they
meet a ceratin condition.
I want the data in the cells below this row (U2:IU197) to also change to red
text if the top row is red.

So basically if U30 contains red text I want the whole of column U30 to turn
to red text. Can this be done? If so how?

Any help would be very much appreciated as I've been struggling for a
while!! :(

Thank you in advance