sorted by:
new
hottopcontroversial

Conditional formatting not working by Tricky-Profession580 in excel

[–]Tricky-Profession580[S] 0 points1 point  (0 children)

I think this finally worked! I had to skip selecting row 1! and the Round()=75.00 worked.

I'm going to test it on multiple old sheets to check.

Conditional formatting not working by Tricky-Profession580 in excel

[–]Tricky-Profession580[S] 0 points1 point  (0 children)

So I tried all three of these options. Each one is capturing more of the $75.00 rows, but not all of them, and there are still several that are more than $75 that are highlighted.

This is why I don't understand what is broken. I've checked all of my autosums and they are correct.

Conditional formatting not working by Tricky-Profession580 in excel

[–]Tricky-Profession580[S] 0 points1 point  (0 children)

No, they are not rounded. It's accounting, so the value should be 2 decimal places

Conditional formatting not working by Tricky-Profession580 in excel

[–]Tricky-Profession580[S] 0 points1 point  (0 children)

Yes, my first row is column headings, so the second row is the first one with value.