|
|
#8
03-06-2014, 09:15 AM
|
|||
|
|||
I attached a copy of you sheet with the formatting rules you specified.
Of the six rule types, use the second: Format Only Cells That Contain Using the range "=$A2" (don't use the quotes) makes the range relative for rows and absolute for the column. You don't really need the $ before the A either. Since you are only doing this over one column, absolute reference for the column is unnecessary. See attached screen capture. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word macro doesn't change font color | Spideriffic | Word VBA | 8 | 11-04-2015 03:47 AM |
| Change Cell Color Based On % Complete | jrfoley3 | Project | 1 | 05-30-2013 05:24 AM |
| how to search and replace BOLD text >> font color change? | dylansmith | Word | 4 | 03-12-2013 09:51 PM |
 change default font color to wdRed
|
tinfanide | Word VBA | 6 | 06-07-2012 06:48 AM |
| change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode