Will Conditional Formatting work?

G

Guest

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!
 
B

Bernard Liengme

With A2 selected, set Conditional Formatting to
Formula Is: =C2="2007 New" ; and set up formatting required.
Or did I miss something?
 
J

JE McGimpsey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting Removal 7
Unable to obtain relative reference using conditional formatting 2
Conditional Formatting 1
Conditional Formatting based on text within a cell w/ text AND num 2
Conditional formatting to a different cell and it contains a formula 7
Conditional Formatting - letters present 5
Conditional formatting using If 1
Conditional Formating with a formula referencing other cells 1

Top