![]() |
|
#1
|
|||
|
|||
|
When cell B2 contains data, I need to have cells B2:G2 (a table row) highlighted yellow. I found the built in rule to highlight a cell when it isn't blank, but it doesn't extend across multiple cells. It also doesn't give me a way to reference Column B as being the cell that determines the formatting, if I try to apply that rule in the other columns.
What is the formula for this? Thanks! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Dragging conditional formatting like a formula
|
sjp1966 | Excel | 9 | 04-13-2017 06:01 AM |
Conditional Formatting Formula
|
teza2k06 | Excel | 1 | 08-22-2014 02:49 AM |
Formula/Conditional Formatting
|
teza2k06 | Excel | 1 | 04-15-2014 06:49 PM |
| Need formula for search and conditional formatting | MikeJedi | Excel | 9 | 01-13-2012 12:38 PM |
conditional formatting formula
|
NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |