View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MomHudd MomHudd is offline
external usenet poster
 
Posts: 7
Default Conditional Formatting for one cell matching another with text

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