Conditional formatting in Excel 2007

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?
 
T

T. Valko

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
 
S

SalesBK

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...
 

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 does not accept text format! 0
Conditional Formatting question.... 1
Need Help with a VBA subroutine 0
Mail Merge Directory Conditional Page Break 0
Paste to excel from word - auto format problem 1
Conditional Formatting 2
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0

Top