| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: How to make conditional formatting work with hyperlinks | Excel Discussion (Misc queries) | |||
| Locate duplicates in a work book by using conditional formatting | Excel Worksheet Functions | |||
| Locate duplicates in a work book by using conditional formatting | Excel Worksheet Functions | |||
| locate duplicates by sing conditional formatting--doesn't work for | Excel Discussion (Misc queries) | |||
| Conditional Formatting Work around? | Excel Worksheet Functions | |||
Linear Mode
