|
|
|
|
#1
03-05-2014, 08:59 AM
|
|||
|
|||
Sorry for my mistake.
Actually I have values in cell A from A2 to A400 and in cell B from B2 to B400. Now I want to apply a formatting or formula for cell B2 to B400 with these conditions. If value in B is equal to value in A then font color is black. If value in B greater than value in A then font color is red. If value in B is less than value in A then font color is green. I want to apply these conditions only on cell B. I think I have explained my problem clearly this time. I have also attached a sample of my worksheet. 
|
|
|
|
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 XP 
Office 2007
Hybrid Mode