Forum Discussion
Empty query table breaks conditional formatting comparing adjacent rows. Any work around?
Using two different versions of 32-bit Excel 2016 (16.0.4549.1000 at home and 16.0.8201.2207 at work) on Win 10,
I have a table with headers starting at A1 that retrieves data from an sql database....
Hi Jack,
With resulting table use structured references for the conditional formatting. It doesn't work with them directly, the workaround is to use INDIRECT. If the name of your resulting table is Tbl and table column name is "a" when like
=INDIRECT("Tbl[@a]")=OFFSET(INDIRECT("Tbl[@a]"),1,0)instead of =A1=A2
Hi Jack,
With resulting table use structured references for the conditional formatting. It doesn't work with them directly, the workaround is to use INDIRECT. If the name of your resulting table is Tbl and table column name is "a" when like
=INDIRECT("Tbl[@a]")=OFFSET(INDIRECT("Tbl[@a]"),1,0)
instead of =A1=A2
Brilliant! thank you!