Another Question lol. Formula this time.

[Nevyn]

Hi again,
I have a worksheet that I want to highlight if there is a number greater
than zero by changing the text colour.

=if(a1>0)colour text red

Any advice would be gratefully received

 

[L. Howard Kittle]

Check out Conditional Formatting under Format. Cell value is > Greater than

0 > OK

HTH
Regards,
Howard

 

[blake p]

The conditional formatting formulas always need to result in true or false,
try this: =a1>0.

 

[Gord Dibben]

See Condtional Formatting.

Cell Value is: greater than 0


Gord Dibben MS Excel MVP