| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format on another cell's value
Hello,
I would like to set up CF to highlight the current cell RED if its contents do not equal the contents of another cell. For instance, if cell A1 has the contents "apple" and cell B1 has the contents "appel" then I want cell B1 to be highlighted RED. Of course, if cell B1 has the content "apple" then I want nothing to happen. I have tried to put the following formula as the CF Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened regardless of the contents of B1 (apple or appel). Thanks for your help, Ricky. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to recognize if another cell's conditional format is true | Excel Discussion (Misc queries) | |||
| CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct) | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
| Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
| Locking a cell's format, but not value | Excel Discussion (Misc queries) | |||
Threaded Mode
