Conditional Formatting Question

[XFILES]

Here's what I'm trying to do. In Cell A1 I want to format it so that the
cell (A1) turns a color when the value in cell G1 is equal to or between
-0.005 and 0.005. I think I'm going to have to do a conditional formatting
formula, but I can't seem to make it work. Hope this makes sense. Any help
is greatly appreciated.

 

[Toppers]

Select A1

formulaIs: =AND(G1>=-0.005,G1<=0.005)

select colour

OK

 

[Rick Rothstein \(MVP - VB\)]

Here's what I'm trying to do. In Cell A1 I want to format it so that the

cell (A1) turns a color when the value in cell G1 is equal to or between
-0.005 and 0.005. I think I'm going to have to do a conditional
formatting
formula, but I can't seem to make it work. Hope this makes sense. Any
help
is greatly appreciated.

Select A1 and then click on Format/Conditional Formatting in Excel's menu.
Choose "Formula Is" from the first field and put this formula in the second
field...

=AND(G1>-0.005,G1<0.005)

It wasn't clear if you want the end points in the range or not. The above
excludes them. If you want them, then add equal signs...

=AND(G1>=-0.005,G1<=0.005)

Rick

 

[XFILES]

Excellent. It worked. Thank you so much!!! I really appreciate the help.

 

[Harlan Grove]

=AND(G1>-0.005,G1<0.005) ....
=AND(G1>=-0.005,G1<=0.005)

Why not just

=ABS(G1)<0.005

or

=ABS(G1)<=0.005

?