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.