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/