Hi,

Just wonder if we can set preferred colour text to the text appearin
using If, Then, Else function? For example, a function having th
following :-

=if(A1="","Error","OK")

I want the word "Error" to appear in red colour when cell A1 is i
blank and the word "OK" to appear in blue colour when cell A1 is fille
up. I know we can do it using Conditional Formatting but that is onl
for 1 condition, but for my situation, there are two conditions.

Please help...

--
Message posted from http://www.ExcelForum.com