You can using Conditional Formatting.

Refer
http://www.contextures.com/xlcondFormat01.html

http://www.youtube.com/watch?v=UmvZ8iYx0Mk

If this post helps click Yes
---------------
Jacob Skaria


"Sri Harsha" wrote:

Hi,
Is it possible that when i give an IF function in excel, the options come
with different formats. For example, if i say that pass and fail are two
results of an IF function, i want pass to be in green and fail to be in red.
It would be great if the background color of the cell changes instead of the
font.

Please let me know if its possible.
Regards,
Sri Harsha.