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" <[email protected]> wrote in message
news:[email protected]...
>