How to change the font color of cell values

gebobs · #1 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.

sky474 · #2 03-06-2014, 09:03 AM

Quote:

Originally Posted by gebobs

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.

There are 6 type of rule in New formatting rule. Which one I should select and will you please explain more clearly about the range you have written ?
"=$A2" & be sure to delete the $ between the A and the 2. I did not get this one.

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