|
|
#2
05-27-2016, 08:58 AM
|
|||
|
|||
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. 
|
|
|
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 |
Windows 10 
Office 2016
Threaded Mode