|
|
#6
03-06-2014, 08:47 AM
|
|||
|
|||
Select all the values in column B. Go to conditional formatting and New Rule.
Format Only Cells That Contain Set condition to "equal to". For the range, type in "=$A2". If you select the cell to enter this, be sure to delete the $ between the A and the 2. Set your formatting. Press OK. Repeat for the other rules accordingly. 
|
| Thread Tools | |
| Display Modes | |
|
|
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