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" wrote in message
...