| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to highlight result of logical function
I am using Excel 2003 and I am using a simple logical function
=If(I8=J8,"PASS",'"FAIL"). This works fine, however, I am trying to figure out how to have the PASS highlighted in Lime Green and FAIL Highlighted in red automatically. Can anyone help? Thank you, Curtis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
| EXCEL 2000 - IF function returns wrong result from logical test | Excel Worksheet Functions | |||
| Formatting color and font to a logical statement result? | Excel Worksheet Functions | |||
| Logical test in IF statement returning incorrect result | Excel Worksheet Functions | |||
| How do I set up multiple logical conditions on one result cell | Excel Worksheet Functions | |||
Threaded Mode
