font color by criterium

  • Thread starter Thread starter Tom Ossieur
  • Start date Start date
T

Tom Ossieur

Could someone explain me how to change the "font color" of
a cell when a certain criterium is not complied with

Example:
IF "value<0.12" THEN "font color" = red

Thanks in advance
 
Go into Format>Conditional Formatting, and you can set it within there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
there may be a better way but I'd use conditional
formating.
use cell value is less than 0.12 and format your font
colour to red
 
Back
Top