IF function
 

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?

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?

Look up Conditional Formatting in Help.

On Tue, 10 May 2005 09:01:15 +0700, "D@annyBoy"
wrote:

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?

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?

"Myrna Larson" wrote in message
...
Look up Conditional Formatting in Help.

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Look at Conditional Formating in Help.

Hi Myrna:

Great minds, etc. <g

Regards,

Vasant

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?