Hello Again =)

I have a table (formatted as a table if that matters...) which works like a planning calender.

There are over 40 rows which means to view some data, I need to scroll down a little bit to see the rest of the columns.

As well as containing some bulky "sumif's" to populate my calander, there is also conditional formatting on the columns which detect a certain number from the "sumif's" and assign it to a color.

when I filter my table reducing it down to a low number of rows, I get no issues but when I remove the filter, the conditional formatting appears to update the color of the text but "forget" to update the color of the cell unless they are re-drawn by either selecting the cells, highlighting the cells with the cursor or scrolling out of the screen and back in again.

is this a known issue with any solutions or work arounds?