Will Conditional Formatting work?
 

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!

Will Conditional Formatting work?
 

With A2 selected, set Conditional Formatting to
Formula Is: =C2="2007 New" ; and set up formatting required.
Or did I miss something?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jennjenn" wrote in message
...
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!

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!