Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
I'm wanting to set up conditional formatting that looks at a range of
interger values. For example I want to mark the following ranges in yellow: -1499 to -200 and +200 to +1499 And these ranges in red: <=-1500 and =+1500 My problem is can I just do this in the conditional formatting section or will I actually need to write it as a Macro? Thanks! -- Teri Albert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
Alright, try this. Assume the test data starts in cell A1 and change
according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work "tralbert" wrote: I'm wanting to set up conditional formatting that looks at a range of interger values. For example I want to mark the following ranges in yellow: -1499 to -200 and +200 to +1499 And these ranges in red: <=-1500 and =+1500 My problem is can I just do this in the conditional formatting section or will I actually need to write it as a Macro? Thanks! -- Teri Albert |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
No dice. When I input the two formulas all of the cells showed up in red (the
color for the +-1500. -- Teri Albert "akphidelt" wrote: Alright, try this. Assume the test data starts in cell A1 and change according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
Good original answer however small error..
First condition - Frmula is: =OR(A1<=-1500,A1=1500) will go (Yellow).. second Condition - Formula is: =OR(AND(A1<=-200,A1=-1499),AND(A1=200,A1<=1499)) will go (Red) Note the equal signs as well Good Luck "tralbert" wrote: No dice. When I input the two formulas all of the cells showed up in red (the color for the +-1500. -- Teri Albert "akphidelt" wrote: Alright, try this. Assume the test data starts in cell A1 and change according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
How do you have it exactly set up because it works perfectly for me. Do you
have any numbers in that list between -1500 and 1500? "tralbert" wrote: No dice. When I input the two formulas all of the cells showed up in red (the color for the +-1500. -- Teri Albert "akphidelt" wrote: Alright, try this. Assume the test data starts in cell A1 and change according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
Still turning everything red. I do agree though I think the "=" needs to be
in there as well. Thanks for your help! -- Teri Albert "ken-hup" wrote: Good original answer however small error.. First condition - Frmula is: =OR(A1<=-1500,A1=1500) will go (Yellow).. second Condition - Formula is: =OR(AND(A1<=-200,A1=-1499),AND(A1=200,A1<=1499)) will go (Red) Note the equal signs as well Good Luck "tralbert" wrote: No dice. When I input the two formulas all of the cells showed up in red (the color for the +-1500. -- Teri Albert "akphidelt" wrote: Alright, try this. Assume the test data starts in cell A1 and change according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing interger values
Woo hoo! I got it to work! Course you know what it was I finally realized I
was doing wrong? Inputting the wrong column value! D'oh! Thanks again for all your help! Both of you! -- Teri Albert "ken-hup" wrote: Good original answer however small error.. First condition - Frmula is: =OR(A1<=-1500,A1=1500) will go (Yellow).. second Condition - Formula is: =OR(AND(A1<=-200,A1=-1499),AND(A1=200,A1<=1499)) will go (Red) Note the equal signs as well Good Luck "tralbert" wrote: No dice. When I input the two formulas all of the cells showed up in red (the color for the +-1500. -- Teri Albert "akphidelt" wrote: Alright, try this. Assume the test data starts in cell A1 and change according to your actual data. Hilight all your data you want the conditional formatting applied to. Click on format--condition formatting In the first condition change Cell Value is to Formula Is Then put in the formula =OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499)) Then you can change the format to yellow or whatever you want Then click add to create another condition and once again select formula is and type in =OR(A1<=-1500,A1=1500) Then format this to red or whatever you want. This should work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
Export Conditional Formatting Values | Excel Worksheet Functions | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Weird interger calculation | Excel Worksheet Functions | |||
Values w/conditional formatting | Excel Worksheet Functions |