Forum Discussion
Conditional formatting duplicates doesn't highlight them
I have the strangest thing. I have a workbook with three columns listing 4 rows of formulas preceded by an apostrophe, to convert them to text. Each row contains the same formula. I can prove it by d...
It looks like Excel is trying to be too clever once again. Even though the apostrophes cause the values to be text, I suspect that Excel still sees formulas.
If you delete all the = signs from A2:C5, the cells will be highlighted.
But it gets weirder. If you remove the = from A2 and B2, Excel will highlight A2, B2 and C2.
I'd report a bug...
HansVogelaar I figured as much, but thought I'd ask in case I missed something obvious. Bug reported!