Hi All - Having problems using my AND formula in conditional formatting... The formula below returns 'TRUE' when pasted into a cell, but does not trigger the conditional formatting rule. Any ideas why?
=AND(INDIRECT("Invoice!"&K$2&ROW(K6))=51258.5,INDIRECT("Invoice!"&L$2&ROW(K6))=46832)
For the purposes of this example, cell K2 simply contains the letter 'k' and L2 the letter 'l'.
Thanks in advance
=AND(INDIRECT("Invoice!"&K$2&ROW(K6))=51258.5,INDIRECT("Invoice!"&L$2&ROW(K6))=46832)
For the purposes of this example, cell K2 simply contains the letter 'k' and L2 the letter 'l'.
Thanks in advance