Forum Discussion
Conditional Formatting a column of a Table when over 100%
JamieGilmore The problem is that your formula in column R for Total % Used is:
=IF(P3=0,"0%",P3/O3)
which mean your 0% is not a number but rather text. Why don't you just use =P3/O3
If you can't for some reason (and I don't know why so tell me because maybe that is something else that should be fixed), then in the conditional formatting you could add a check ISNUMBER($R3) so it would look like:
=($R3>=101%)*ISNUMBER($R3)
Perhaps you may provide small sample file to illustrate which exactly type of rule do you use and which are references in this rule?
Unfortunately, I cannot share the file due to private information (an unable to replicate the issue). Here are two screen grabs of my current situation with 5 rows that are highlights in the ASR column, even though their total % used is 0%, and the second image is if I manipulate a row to be over 100%, how it highlights as it is supposed to.
I've also attached an image of the formatting rule I have in place, which is actually for >101%, as I thought changing it from 100% might help (it didn't). The formula is =$S7>+101%
Note: Column S is the "Total % Used" column.
