Hi,

For more information on Conditional Formatting, refer to this link:
http://office.microsoft.com/en-us/ex...CL100570551033

Challa Prabhu

"Min" wrote:

I have 2 columns of data.
If the number in b1 is less than a1, I want the number in b1 to be displayed
in pink.
How do I do this?
Many thanks for any help!