Forum Discussion

MrsBenson's avatar
MrsBenson
Copper Contributor
Aug 27, 2021

Conditional formatting Issue

I have data in Microsoft Excel that I use conditional formatting on.  To ensure that all entries for a particular day are referenced in a daily total cell, I have set up a totals cell for the daily totals and have it conditionally formatted to flag red if the total there is different then the weekly total shown (See the screen shot).  However, on some occasions, for reasons I am stumped to find, the system will flag the daily column red when the totals do in fact match.  I have checked the formatting of the cell, the same on both.  I have checked for leading and trailing zeros, there are none.  Both are exactly the same equation set ups, they are a =SUM(the cells immediately above for the entire week).  I have deleted and reset the conditional formatting for this particular cell, no change.  I am uncertain what else can be done to possibly fix this issue.

    • MrsBenson's avatar
      MrsBenson
      Copper Contributor
      With a rounding error, would that be something that lays in the formatting of the cells. At this time all of the cells, the ones being used for the sum as well as the sums themselves, are all formatted using the custom format of "[h]:mm"
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        MrsBenson Don't know. Time entries are in fact numbers with quite a few decimals. Summing 5 summed values of 6hrs and 38min that add up to 33hrs and 10min may give a slightly different total than summing 10 individual. But perhaps it's not that at all.

Resources