You can do it by using Conditional Formatting. Have a look in the below
links for more details about it.

http://contextures.com/xlCondFormat01.html
http://contextures.com/xlCondFormat02.html
http://contextures.com/xlCondFormat03.html

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Chris H" wrote:

When using an "IF" formula and the value is true, how do i change the color
in the results cell. I.E. if A61,"black", how do i get the cell to turn
black and say black