| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - For 1 cell based on contents of any cell
Hi! I'm trying to set up conditional formatting in a column heading cell
where the cell will highlight in red if any of the cells in the rest of the column have Yes in them. Example: In Cell A10, I want the cell to highlight red if any of the cells in A11 thru A100 have Yes in them. Either Yes or No will be entered in each row of the column. I'm using Excel 2003. Thanks! -- D J Hendren |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
| Formatting one cell based on the contents of another cell | Excel Worksheet Functions | |||
| Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
| Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
| Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
Threaded Mode
