Conditional Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top