| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional formatting in Excel 2007
i have a worksheet with a list of prospects. I want the row to be
conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help? -- Brad |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional formatting in Excel 2007
Let's assume you want to highlight the range A1:E1 if E1 = quote.
Select the range A1:E1 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine....... Enter this formula: =$E1="quote" Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "SalesBK" wrote in message ... i have a worksheet with a list of prospects. I want the row to be conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help? -- Brad |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional formatting in Excel 2007
Cheers - all sorted
-- Brad "T. Valko" wrote: Let's assume you want to highlight the range A1:E1 if E1 = quote. Select the range A1:E1 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine....... Enter this formula: =$E1="quote" Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "SalesBK" wrote in message ... i have a worksheet with a list of prospects. I want the row to be conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help? -- Brad |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional formatting in Excel 2007
You're welcome!
-- Biff Microsoft Excel MVP "SalesBK" wrote in message ... Cheers - all sorted -- Brad "T. Valko" wrote: Let's assume you want to highlight the range A1:E1 if E1 = quote. Select the range A1:E1 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine....... Enter this formula: =$E1="quote" Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "SalesBK" wrote in message ... i have a worksheet with a list of prospects. I want the row to be conditionally formatted when a change one cell to "quote". i can get that particular cell to change, but i want it for the whole row! Can anyone help? -- Brad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 conditional formatting bug? | Excel Discussion (Misc queries) | |||
| Conditional Formatting In Excel 2007 | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
| Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
