Cell format
 

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

Cell format
 

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

" a écrit dans le
message de ...
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