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.