Hey guys!

I'm currently struggling with a small formating code and like to refresh a row of formulas that have a macro for background color check in them.
Unfortunately the refreshing methodes that I found only refresh if a cell value changes, not the background color. I also want to change True and False to 1 and 0 somehow.

Table.jpg
Code.jpg

Sheet1.xlsm