Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight data that doesn't fall within certaint range
I need to know if there is a way to have data that doesnt fall within a
certain range to come up a different color so I will know it is not within range by looking at it and not have to look up to find out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight data that doesn't fall within certaint range
I think Conditional Formatting will do what you're asking for....
If the values are in A2:A20 and you want to flag any values that are NOT between 100 and 200, inclusive... try this: Select A2:A20, with A2 as the active cell. Then....from the Excel Main Menu: <format<conditional formatting Condition_1: Formula is: =OR(A2<100,A2200) Click the [format] button....set the color...Click [OK] Click [OK] Is that something you can work with? Post back if you have more questions. -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Rob Allmighty" <Rob wrote in message ... I need to know if there is a way to have data that doesnt fall within a certain range to come up a different color so I will know it is not within range by looking at it and not have to look up to find out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight data that doesn't fall within certaint range
You can use Condition Formatting for this (on the Format menu). Choose
Formula Is rather than Cell Content Is in the CF panel and set up your condition, eg: =OR(A1<0,A110) then click on the Format button, click the Patterns tab and choose your colour - click OK twice to exit the CF panel. The formula I have given will apply to cell A1 and will highlight the cell if A1 is outside the range 0 to 10 inclusive - adjust to suit your requirements. Hope this helps. Pete On Sep 20, 1:26 am, Rob Allmighty <Rob wrote: I need to know if there is a way to have data that doesnt fall within a certain range to come up a different color so I will know it is not within range by looking at it and not have to look up to find out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight a range for data entry | Excel Discussion (Misc queries) | |||
Adding amounts that fall within a range | Excel Worksheet Functions | |||
Counting if numbers fall within a specified range | Excel Discussion (Misc queries) | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) |