Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
"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 |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |