Conditional Formatting formula (one cell matching another with tex

  • Thread starter Thread starter MomHudd
  • Start date Start date
M

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
 
Try this formula:
=not(or(d18=g7,d18=h7))

In the future, please get your Caps Lock key fixed, so you can stop
shouting.

Regards,
Fred
 
Back
Top