| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting based on other cells
unless you want to enter them individually, you will need to enter the
formula with absolute references. Select A2 through A10 and click format-conditional formatting. Select "formula is" instead of "cell value is", and then enter this modified formula. =OR($A$1="OK",$A$1="YES",$A$1="MAYBE") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
| Can a conditional formatting result affect another cell or cells | Excel Worksheet Functions | |||
| Omitting Some Cells From Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
| counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Hybrid Mode
