I NEED A FORMULA TO DO THIS:

IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7


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

BTW... G7="DAYS" AND H7="HALF"

"MomHudd" wrote:

I NEED A FORMULA TO DO THIS:

IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7


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

Use this as the CF formula for D18:
=AND(D18<G7,D18<H7)
Format to taste, ok out

p/s: Do not use all caps in your posting (its impolite and difficult to
read). Do not multi-post, ie post the same question in multiple excel
newsgroups (it wastes responders' time)
--
Max
Singapore
---