IF ___ then fill color???
 

Thanks in advance...

Is this possible?

I have a column of numbers with an autosum at the bottom. I'd like to fill
any cell that is greater than 1/2 of 1 percent of the total at the bottom
with a color (Yellow? Doesn't matter).

Again, is it possible? If so, how?

If not, is it possible to fill the cell next to it in an adjacent column?

THANKS!!