Forum Discussion
Difficulty with conditional formatting formula
Michael, you don't need =A1=ABS(..., it's simply = ABS(...
=ABS(Maxima!C11*0.806494192-C11)<5
Hi Michael,
In this case
=ABS(Maxima!C11*0.806494192-C11)<5
You don't need IF, formula returns TRUE of FALSE itself. Just in case, your formula also could work if you use TRUE instead of "true", same for FALSE
Thank you for your reply. I omitted, which I know is very frustrating for people trying to help, that I attempted that very same formula.
I've collected a few images to perhaps show more clearly what I have.
This formula works in some cells (those where the approximation is spot-on)
If I change it the way I think it should work, using a formula to allow for a few points variance (the formula you supplied, in the way I could get it to work in the conditional formatting text box, then not even the cells highlighted under the previous example are highlighted.
Perhaps you can spot what I'm doing wrong. Your help is greatly appreciated.
Michael, you don't need =A1=ABS(..., it's simply = ABS(...
=ABS(Maxima!C11*0.806494192-C11)<5
Sergei, thank you! Finally it dawned on me. I'm actually elated, because a whole part of the complexities around entering formulas in conditional formatting has just cleared up. I'm almost wishing there was a way I could update the MS documentation to clarify it, since I just couldn't grog it.
But now, I feel a whole lot more educated. Thanks again.Michael, the main rule the formula shall return TRUE of FALSE. In case of complex formula or if you are not sure how it works better to play with it in the worksheet cells first, after that copy/paste into the conditional formatting rule.