I am currently working on making a spreadsheet that will figure out which class I should be in based on times. That all works and outputs if I should be in the class to a TRUE/FALSE cell. My conditional formatting uses that output cell to highlight the cells on my class list that shows what class I am in. However, the formatting only applies to some of the cells when it should, and applies the formatting to some cells when it shouldn't, even though there is only one cell controlling the formatting for all the cells.
I cannot share the document because of how the school has set up our accounts, but I can show this screenshot:
Edit: I made this dummy spreadsheed, the left box of C1:D8 has the custom formula of
=A1, and the right box (F1:G8) has
=EQ(A1,TRUE), and A1 is the bool