|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
05-31-2014, 08:01 AM
|
||||
|
||||
You said one of the cells in each worksheet has the name of the color, right? So that would be the formula: Color particular cells yellow if $X$1="Yellow" (or whatever). Wouldn't that work for you?
|
| Tags |
| conditional formatting, reference, sheets |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Header must toggle text & color + show count of conditionally formatted cells below | Franktoon | Excel | 3 | 02-18-2014 02:10 PM |
 How can I count cells based on their fill color that was set by conditional format
|
trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
|
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
|
Conditional color fill based on presence of data
|
avanderh | Excel | 11 | 07-28-2011 09:10 AM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode