| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format failure
Thank you, that did it!
"JE McGimpsey" wrote: Well, when you enter a value (other than TRUE), the value is no longer $C$3=Q1 (i.e., TRUE, presumably, since the format was applied), so the conditional format goes away. If you want to make the CF dependent only on C3 and Q1, use the dropdowns and input box to read Formula is =$C$3=Q1 e.g., "Formula is" rather than "Cell Value is" In article , marty wrote: I have set the following conditional format: Cell Value is equal to =$C$3=Q1 in cell C2 and have the cell change color. The conditional format works if C2 is blank but whenever a value is present the color reverts back to the default. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditional format by referencing failure/success? | Excel Worksheet Functions | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| Failure to display currency format | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Threaded Mode
