CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT

[MomHudd]

I NEED A FORMULA TO DO THIS:

IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR
H7("HALF")


MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN
D18 WILL TURN RED

 

[David Biddulph]

CF/ Formula is

=AND(ISTEXT(D18),D18<>G7,D18<>H7)

Select your red format.

 

[Gary''s Student]

Use ForumaIs:

=(AND(D18<>D7,D18<>H7)) and pick the proper font color.

 

[MomHudd]

THANKS! THAT WORKED PERFECTLY!

Use ForumaIs:

=(AND(D18<>D7,D18<>H7)) and pick the proper font color.

 

[Max]

You should take the trouble to close-off your identical query in .newusers as
well. The response there carries more useful notes for you beyond the
immediate answer.