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:

the spreadsheet 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 TRUE.

  • I am afraid your image is not explanatory enough. Please create a dummy sheet with dummy data (but real formulas) and share it as view only. – marikamitsos Oct 25 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.