View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Will Conditional Formatting work?

One way:

Use the same criteria. Select column A (with A1 active) and enter

CF1: Formula is =C1="2007 NEW"
Format1: <pattern/<purple, <font/Bold


In article ,
jennjenn wrote:

My spreadsheet contains conditonal formatting that tells cells in coumn C to
BOLD & color purple when "2007 NEW" is entered.
I would like the cells in column A to do the same
So, if Cell C2 = BOLD & Purple then Cell A2 = BOLD & Purple
Thanks!