Help with structured references

Hi and welcome to the forum

1st, you dont need to use SUM() for a calc like that (not that it would cause your formula to not work, its just not necessary)

2nd try replacing the names in your formula with the actual cell references

The only time you can use names like that, is if you have created range names for those cells

you would use "format all cells based on their value" is you want to apply the rule to that specfic cell...ie if you want to color G2 AND G2 contains the data that will decide if the change happens

You would use "use a formula" if you want to change the color of G2, but another cell (F2 for instance) contains the data that will decide if the change happens

Hopefully, based on that, you can decide?

When you create formulas for CF, you need to structure them a little differently. CF works on a TRUE or FALSE, so your formula needs to give 1 of those as its answer.

What I sometimes do, is practice creating the formula IN the worksheet, next to data that I will be working with. That way, you can play with the formula until it gives you what you want.

try something like =cell_ref>-0.98

the cell_ref is a single cell ref, not a range....=$G2>=.98 (note the absolute reference, as well)

when you apply CF, 1st, highight the range you want to apply it to (you can adjust the range inside CF, too)
Then go into CF and create your rule/s.

Hi Mzgam3 and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.