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
|