Thread: IF function
View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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?