IF Statements

  • Thread starter Thread starter Shelley
  • Start date Start date
S

Shelley

Hi there.

I have been working on an IF statement and would like to
know if you are able to add font colour as a result. For
example,=IF,(G9<=4,"font.colour.Blue","font.colour.Red").
If someone knows the answer it would be greatly
appriciated!!

Many Thanks
 
Shelley,

You can do that with conditional formatting

Format|Conditional Formatting select Formula Is

And use your formula

=G9<=4

and select a format with a blue font

Then either use a second criteria for the alternative when G9>4 or leave
that as the basic cell format.

PC
 
Paul,

Thanks for this information. I have tried it and it works
brilliantly. Thank you, much appreciated!
 
Back
Top