Forum Discussion
Conditional formatting formula not recognizing equals
Working in Excel Table "Alignment" I'm comparing the value of two cells, each of which contains a lookup. e.g. =VLOOKUP([@[PFD Seq]],OrigPFD,13,TRUE) The lookups values were calculated indep...
I actually adjusted the workbook to put the rounding function on the data source instead of the lookup function. Still no luck.
BUT! I changed the the condition to formula and set it as =C$1=D$1 and voila. Perfect.
Why the prefab comparison doesn't work is beyond me...
What is important is to write the formula with in mind that you are in fact editing the formula for the top-left-most cell of the range which contains the CF rule. And that you must pay attention to using absolute and relative references in the right way.