Andrew,

You can't do it in a formula (without a VBA function), but just change the
CF function to test the other criteria as well, that is only set it if it is
past the certain date but not with the other criteria.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"andrewowens" wrote in message
...
Hi -
I have a cell with a date in it. I've conditionally formatted the text
to be red if it is past a certain date. What I need to do now is
change the text back to black if the date is past a certain date but
the criteria in another cell is a certain criteria. I don't know how
to address text color w/in a formula. Here's an idea of what I have
(minus the correct way to format the text forecolor property):

IF(AND(Y:Y="red", Z:Z="G"), "black", "red")

The "G" is the other criteria.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/