How to auto text colour change to green if logical function true?

A

Al

Hi Guys/Gals

How can I get the text in a cell to automatically change colour from black
to green when a logical function returns a 'TRUE' result?

Please
 
C

carlo

Select the cell you want to change, then
go to Format --> Conditional Formatting...

there you can enter the Formula which will
be true or false and then you can define the
format of this cell.

hth

Carlo
 
Top