Conditional Formatting with Slicers - losing formats

Hello,

I have a chart with gantt bars that is filtered with a slicer. I made a formula to colour code the bars by project name but when I apply the slicer I lose the colour formatting. I cannot use getpivotdata as a workaround since the information I'm working with are start and end dates (cells in formula below). Does anyone have any suggestions or different formulas to to try?

=IF(EXACT(Data!$B2, "Project A"),AND(L$9>=$E10,L$9<=$G10), "")

I also lost one projects formatting, arbitrarily it seems, after a couple days when reopening the file.

One other format issue that I had was that I was trying to flag actuals approaching budget within a percentage using =$K11>=$J11*0.95. When I open the file the next day, it changes the area it formats (see photo)
Screenshot 2021-06-07 084728.png

Any help would be greatly appreciated.

Thank you