lad
10-10-2007, 05:12 AM
Hi,
I have a number of values running down column C. Rather than applying conditional formatting to the column to change the text colour of these values what I would like to do is change the colour of text in the cell next to each value (ie. Column D).
I can do this for an individual cell using a formula in conditional formatting which appears something like =$C$4<5 and would apply to $D$4 but because these aren't relative I can't copy this formula down for each cell in Column D. Make sense?
Is there a way I can do this using some other method?
Cheers.
I have a number of values running down column C. Rather than applying conditional formatting to the column to change the text colour of these values what I would like to do is change the colour of text in the cell next to each value (ie. Column D).
I can do this for an individual cell using a formula in conditional formatting which appears something like =$C$4<5 and would apply to $D$4 but because these aren't relative I can't copy this formula down for each cell in Column D. Make sense?
Is there a way I can do this using some other method?
Cheers.