Try, you will answer your own question.
--
HTH
Bob Phillips
"D@annyBoy" wrote in message
...
forgot to mention that I am running OL2003
I am entering data in D2, E2, and F2 and results are in G2
I suppose I can use conditional formatting ........................
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Look at Conditional Formating in Help.
--
Vasant
"D@annyBoy" wrote in message
...
I have this function
=IF(AND(F2=$D2,F2<=$E2),"PASS","FAILED")
is it possible to show results, PASS in blue and FAILED in red colour?
|