Thread: How can I change the colour of cells using an IF function?

You can't.

But you can use conditional formatting to test its value and set a colour
accordingly.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gctexcel" <gctexcel@discussions.microsoft.com> wrote in message
news:AEA20C54-E069-460E-B35D-49C855249368@microsoft.com...
>