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

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

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

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