Change color of text if conditions are met.

[tnielsen91]

I have two columns. Both columns have dates ie - 4/7/2007 and 4/8/2007. I want to create a formula that automatically turns the text in the column with the later date red (or a different color). In the above dates, the 4/8/2007 will be red text and the 4/7/2007 would remain black.

[BigBas]

You will need to use a conditional format. Assuming your information is in range A1:B10, click on Cell A1, go to format>conditional format>click "formula is>enter this formula: =AND(A1=MAX($A1:$B1),$A1<>"",$B1<>"") next, assign the format that you would like, and accept. Next, right click and copy cell A1, highlight cells A1:B10>paste special>formats