![]() |
|
|
|
#1
|
|||
|
|||
|
Select the cell you already have conditionally formatted. Press Conditional Formatting and then Manage Rules. In the field 'Applies to' write the range with all your columns. OK. |
|
#2
|
|||
|
|||
|
The problem is the formatting of column D is dependent on the letter in cell D11, Column E is dependent on the letter in cell E11, and Column F on the letter in F11. If I just tell the conditional formatting to apply to all cells in column D,E, and F, it will base the conditional formatting of Column E and F on the letter in cell D11.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formating
|
MJS16 | Excel | 16 | 12-01-2016 01:09 PM |
| Conditional Formating | MaineLady | Excel | 2 | 10-30-2016 02:08 PM |
Conditional Formating
|
Aseren | Excel | 14 | 02-18-2016 01:05 PM |
| Conditional Formating | MaineLady | Excel | 1 | 11-05-2014 06:37 PM |
more Conditional Formating
|
princeofsadness | Excel | 2 | 09-05-2011 02:14 AM |