I’m having difficulty with a conditional format and I would appreciate someone reviewing the attached worksheet and letting me know what’s preventing me from getting the desired results.
I have a conditional format in F9 that compares the value between F9 and C46. If the values are NOT equal, then the background color and font in F9 changes (background = red | font = Yellow).
C46 is the sum of C1:C45.
F9 is the sum of F1:F8 which sums column C to recap values based on year using a SUMSIF statement.
What's confusing me, the value in both F9 and C46 are the same, but my conditional formatting is treating then as not being equal.
If I change “any” values in column C (C1:C45), my value in both F9 and C46 correctly reflects the new totals and my conditional formatting works; however, if I change the value back to the original amount, F9 and C36 correctly reflects the original totals (both being the same), but my conditional format shows they are not equal.
I’m sure it’s something obvious that I’m overlooking, but I reviewed my conditional format for errors, ensure there were no other rules that would take precedence, numbering format, rounding, etc.