Change text color in an IF...THEN...ELSE formula

  • Thread starter Thread starter andrewowens
  • Start date Start date
A

andrewowens

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.
 
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)
 
Back
Top