Conditional formatting in Excel 2007

  • Thread starter Thread starter SalesBK
  • Start date Start date
S

SalesBK

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?
 
Let's assume you want to highlight the range A1:E1 if E1 = quote.

Select the range A1:E1

Goto Home tab>Styles>Conditional Formatting>New Rule>Use a formula to
determine.......

Enter this formula:

=$E1="quote"

Click the Format button
Select the desired style(s)
OK out
 
Cheers - all sorted

--
Brad


T. Valko said:
Let's assume you want to highlight the range A1:E1 if E1 = quote.

Select the range A1:E1

Goto Home tab>Styles>Conditional Formatting>New Rule>Use a formula to
determine.......

Enter this formula:

=$E1="quote"

Click the Format button
Select the desired style(s)
OK out
Click to expand...
 
Back
Top