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– user55949Apr 11, 2019 at 15:31
-
Oh, you wrote a lot below the answer. That should be in your question– user55949Apr 11, 2019 at 15:32
Add a comment
|
1 Answer
- 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. Mar 11, 2019 at 20:43
-
-
docs.google.com/spreadsheets/d/… some of the cells that are causing me trouble are: P7, BH6, BX3, BX7, CH3, CP4 Mar 12, 2019 at 13:52
-
How do I share with everyone? I only have the option of entering e-mail addresses. Mar 12, 2019 at 13:54
-
1