How to change the font color based on another column

[stile]

I have a column of dates which is column A. I have another column, B, which is either Approved or Rejected (so 1 or 0). How can I set the font color on column A1 based on whether B1 is Approved or Rejected?

Thanks in advance.

 

[Aladin Akyurek]

On 2002-10-18 13:04, stile wrote:
I have a column of dates which is column A. I have another column, B, which is either Approved or Rejected (so 1 or 0). How can I set the font color on column A1 based on whether B1 is Approved or Rejected?

Thanks in advance.

(1.) Select all the relevant cells in A.
(2.) Activate Format|Conditional Formatting.
(3.) Choose Formula Is for Condition 1.
(4.) Enter the following in the white box:

=B2=1

(5.) Activate the Format button.
(6.) Choose a color from the Font tab.
(7.) Click OK, OK.

Note. I assumed that the data start at row 2, hence B2 in the formula. I also assumed that B houses 1 for Approved and 0 for Rejected.

 

[JohnG]

First format the cell(s) with Custom and enter [Red]"REJECTED";[Green]"PASS"

Now enter a formula where 1 true(rejected) 0 False(OK) such as
=IF(B1>2,1,0)