I am using Excel 2007 and I want the values in column AB10 to AB580 to be shaded if they are less than the values in column W in their corresponding rows. I can accomplish this using conditional formatting 'Highlight Cells Rules', 'Less Than' but I would have to do this for every individual cell.

Please help!

EggHeadCafe - Software Developer Portal of Choice
Web-Based Application Tuning On Windows 2000
http://www.eggheadcafe.com/tutorials...ation-tun.aspx

You can do it all at once...

Select the *entire* range AB10:AB580 starting from cell AB10. Cell AB10 will
be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula will be relative to the active cell.

Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=AND(AB10<"",AB10<W10)
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


<Daron Shiflet wrote in message ...
I am using Excel 2007 and I want the values in column AB10 to AB580 to be
shaded if they are less than the values in column W in their corresponding
rows. I can accomplish this using conditional formatting 'Highlight Cells
Rules', 'Less Than' but I would have to do this for every individual cell.

Please help!

EggHeadCafe - Software Developer Portal of Choice
Web-Based Application Tuning On Windows 2000
http://www.eggheadcafe.com/tutorials...ation-tun.aspx

Daron -

Select the whole range first, then add the conditional formatting as you
would for the first cell in the range.
--
Daryl S


"Daron Shiflet" wrote:

I am using Excel 2007 and I want the values in column AB10 to AB580 to be shaded if they are less than the values in column W in their corresponding rows. I can accomplish this using conditional formatting 'Highlight Cells Rules', 'Less Than' but I would have to do this for every individual cell.

Please help!

EggHeadCafe - Software Developer Portal of Choice
Web-Based Application Tuning On Windows 2000
http://www.eggheadcafe.com/tutorials...ation-tun.aspx
.