0

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 – Jan Doggen Apr 11 at 15:31
  • Oh, you wrote a lot below the answer. That should be in your question – Jan Doggen Apr 11 at 15:32
0
  • select a range where Conditional formatting should be applied (A1:Z)
  • then choose Greater than or equal to
  • and enter your desired number (5)

    0


your issue is that P7 is not really 98%. it's rounded up! you can check this with .00 button:

0

you can fix it also in the early stage with: =ROUNDDOWN(SUM(N7)/(N7+O7),2)

0

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

Your Answer

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

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