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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to conditionally format entire row from contents of one cell?
Try this:
Select the rows to be impacted, choosing Row_7 last. (do that by holding down the [ctrl] key while you select the row number at the left of the window) From the Excel main menu: <format<conditional formatting Formula is: =($D7="R") Click the [format...] button and select the format to be used. Click the [OK] buttons when done. Note_1: If the current row is NOT Row_7, adjust the formula to reference the current row number. Note_2: the dollar sign ($) locks that part of the reference, so every cell in that row will test Col_D. Note_3: that CF formula is NOT case sensitive. If you need a case sensitive method, use: =EXACT($D7,"R") Does that help? *********** Regards, Ron XL2002, WinXP "MaryatSHO" wrote: 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! |
Reply |
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 |