View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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