You want conditional formatting

See http://www.contextures.com/xlCondFormat01.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Yashes" wrote in message
...
i need to create a "if statement" in Excel and i need to know how to make
the
cell change colour if it is true

Thanks