Conditional Formatting Broken?
I'm trying to make a cheatsheet for a farming minigame where seeds are bred and collected. The sheet lays out the different breeding combinations as well as an overall status tracker where 1/2/3 will represent the stage of collection I am at.
I would like every instance of a seed to be conditioned based on the according status code. For example, every instance of Baker's Wheat should turn green when I set the status value to 1, representing that that seed is in my collection.
I am having trouble with the conditional formatting. Only the first cell I apply the conditional formatting to is working correctly. I used the "paint format" to attempt to transfer this behavior to a second instance and it turned green, but it won't turn back to white if I set the tracker to 0 and won't turn to other colors for 2 or 3. If I copy the formatting to further instances, it won't do anything at all. This is even if I add additional cells manually to the conditional formatting menu with commas like: B1, B4, D4, H4. I can click on those cells and see the conditional formatting rule appear, but it just doesn't change color.
Note this sheet was originally created in LibreOffice Calc (ods) to save me the time of arranging all the art again. None of the conditional formatting transferred over, so that is when I discovered this issue.
Here is the sheet with Editor access: https://docs.google.com/spreadsheets/d/1EXWqyR-zeWwcpg6gJHVtOTBXz3voEfO0uM5TbxgUxQc/edit?usp=sharing