Thread: Cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rjc44@iprimus.com.au is offline
external usenet poster
 
Posts: 12
Default 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