Thanks for the speedy response Pete!

I've tried this but it doesn't work. I think it might be becasue the top row
has dates in it and the other cells just have 1 digit figures.

The CF for the top row is

If cell value is greater than or equal to =$g$1 then
condition.....
G1 is TODAY-365

Perhaps my initial way of working out what I want is better.....

I basically need a formula to count the non blank cells within a rolling
year. - The dates
are in the top row, (U1:IU1) and the days/occassions sick are in the rows
below (U2:IU2, U3:IU3 and so on)

My initial formula: =SUMIF(($S$1:$IV$1=TODAY()-365)*S2:IV2) adds up
all the figures (total days sick) correctly within the rolling 12 months,
but I also need to count the non blank cells (occasions) for the same
condition. i.e if someone has been off sick for 4 days in one week I want
excel to count this as 1 rather than 4.
I thought that changing 'SUMIF' to 'COUNTIF' would work, but it doesn't -
hense the diffrent strategy!

I've tried loads of different things but nothing seems to work. I'm well and
truely stuck!!! :(

Jennie

"Pete_UK" wrote:

You need to apply the same conditional formatting criteria that you
have in row 1 to the rows below. You may need to use Formula Is rather
than Cell Value Is in the first box of the DF dialogue. You can
highlight the range and enter the criteria once, rather than do it for
every cell individually.

If you are still uncertain, post back with details of your current CF
criteria.

Hope this helps.

Pete

On Jun 19, 2:33 pm, Jennie wrote:
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 certain 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