Forum Discussion
Solved
Conditional Formatting a column of a Table when over 100%
I have a large excel file containing projects with their associated propose cost, invoice cost, etc. I set up a conditional formatting rule, where if the column for "total Percent Used" is greate...
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?