View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lostinthought Lostinthought is offline
external usenet poster
 
Posts: 1
Default 2007 Excel conditional formating, reference cell containing specif

I need to add a fourth condition to an array. This fourth condition needs to
reference a cell only when that cell contains a specific text string. The
preceding numbers will change, however the text will be based off of three
sets of specific text. Basicaly N1 changes color if A1 CONTAINS xyz. N1
already changes color three ways based off of a date formula. Please advice.