| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
