Cell format

[rjc44]

Hi,
In cells A8:A18, I have formulas that return a number
value. These cells are formatted to display in Blue.

How can I write a formula in each of the 10 cells to say
something like this....
=If(c8="y",make the returned number value in A8 etc, the
color Red,"") ...............

Is this possible and could anyone assist with this please.

Thankyou,
Rick

 

[papou]

Hi Rick
Have a look at Conditionnal Formatting available from Format
Regards
Pascal