CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
 

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

CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
 

CF/ Formula is

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

Select your red format.
--
David Biddulph


MomHudd wrote:
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

CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
 

Use ForumaIs:

=(AND(D18<D7,D18<H7)) and pick the proper font color.
--
Gary''s Student - gsnu201001


"MomHudd" wrote:

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

CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
 

THANKS! THAT WORKED PERFECTLY!

"Gary''s Student" wrote:

Use ForumaIs:

=(AND(D18<D7,D18<H7)) and pick the proper font color.
--
Gary''s Student - gsnu201001


"MomHudd" wrote:

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

CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
 

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.
--
Max
Singapore
---