CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
 

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

CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
 

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

CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
 

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
---