CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL

  • 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 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)
 
Back
Top