I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and started over. I have been entering the formatting one cell at a time to see if that would solve my problem. There are still cells that the formatting doesn't come up in. I am trying to have a cell turn green if the number in the cell is greater than or equal to a certain number. HELP! I'm going crazy!
- select a range where Conditional formatting should be applied (
- then choose Greater than or equal to
and enter your desired number (
your issue is that P7 is not really 98%. it's rounded up! you can check this with .00 button:
you can fix it also in the early stage with: