Conditional Formatting Question
 

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.

Conditional Formatting Question
 

Select A1

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

select colour

OK
"XFILES" wrote:

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.

Conditional Formatting Question
 

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

Conditional Formatting Question
 

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

"Toppers" wrote:

Select A1

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

select colour

OK
"XFILES" wrote:

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.

Conditional Formatting Question
 

"Rick Rothstein (MVP - VB)" wrote...
....
=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

?