| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula help
=OR($F$1=5,$O$1=5000)This formula works fine if both conditions are met. How
would you rewrite it to show in red if only one or both conditions are met. Say there is only a 5 in F1 and no 5000 in O1 or 5000 in O1 and no 5 in F1. I need it to show in red if only one condition is met. Thanks in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
