Conditional Formatting

[Daron Shiflet]

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/tutorial...8f-a64d669811dc/webbased-application-tun.aspx

 

[T. Valko]

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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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

 

[Daryl S]

Daron -

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