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!

  • Show us what you did and the data in your sheet working correctly and incorrectly
    – user55949
    Commented Apr 11, 2019 at 15:31
  • Oh, you wrote a lot below the answer. That should be in your question
    – user55949
    Commented Apr 11, 2019 at 15:32

1 Answer 1

  • select a range where Conditional formatting should be applied (A1:Z)
  • then choose Greater than or equal to
  • and enter your desired number (5)


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: =ROUNDDOWN(SUM(N7)/(N7+O7),2)


  • That is how I enter the formatting but there are still cells where it doesn't work. Commented Mar 11, 2019 at 20:43
  • I don't know how to do that Commented Mar 12, 2019 at 13:27
  • docs.google.com/spreadsheets/d/… some of the cells that are causing me trouble are: P7, BH6, BX3, BX7, CH3, CP4 Commented Mar 12, 2019 at 13:52
  • How do I share with everyone? I only have the option of entering e-mail addresses. Commented Mar 12, 2019 at 13:54
  • 1
    Yay! It fixed it! Thank you so much! It was driving me crazy! Commented Mar 12, 2019 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.