I am trying to apply some conditional formatting to a cell on Google Sheets. I want the cell to change green if it is larger than another cell, red if it is less, and yellow if it is the same.
However, for some reason when I add these rules, the only one that seems to take any effect is the less than criteria.
I have tested it somewhat and it seems that the formatting isn't applied unless it is the 'less than' criteria that is selected. So for instance, I tried out the greater than criteria, and made it true and it didn't apply the formatting, but as soon as I changed it to less than it worked.
Not to mention that it applies the formatting regardless of where the criteria is met or not and only doesn't apply the formatting if the cell is empty.
This isn't the end of the world, but it is frustrating and would make the at a glance of the sheet I want to apply it to much nicer.
I've likely missed some important details, so I'm obviously open to questions.