#1
|
|||
|
|||
Need conditional formatting formula
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! |
#2
|
|||
|
|||
Select B2:G2.
Click Conditional Formatting and select New Rule. Select Use formula to determine ..... In the field Format values where this formula is true write: =$B$2<>"". Click the Format and format as you wish. OK. |
Thread Tools | |
Display Modes | |
|
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 |