| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to conditionally format entire row from contents of one cell?
I'm trying to format a whole row based on the contents of one cell.
Like this... If D6 or D7, 9, 12, 30, etc. are filled with the letter "R", then I want that whole row (i.e. 6, 7, 9, 12, 30) to be shaded red. How can I do this using conditional formatting. I can get the particular cell to shade red, but not the whole row...based on that one cell. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
| Printing Entire Contents of Cell | Excel Discussion (Misc queries) | |||
| Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
Threaded Mode
