Using AND Formula in Conditional Formatting

[scheldor]

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

 

[Gerald Higgins]

Just an idea - I'm not sure about this but could it be because it's referring to a different sheet ?

Can you get this formula to work in Conditional Formating actually on the "Invoice" sheet ?

 

[scheldor]

Thanks for the reply - it's made me realise that the INDIRECT function is causing the issue. Still not sure why, but I've been able to find a way of referencing the sheet I need without using INDIRECT and the conditional formatting now works.