Conditional Formatting formula (one cell matching another with tex

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
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT 4
Conditional Formatting for one cell matching another with text 2
CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL 2
Offset, Match Questiond 7
Conditional Formatting 2
Conditional Formatting with average formula and variance 9
Conditional Formatting 1
Excel 2007 - formula to display text over a range of values 1

Top