Kieran P schrieb:
So, I hope I explained myself well enough. Is there any way to do this? Here
are my current test lines for the conditional (none of which work). I'm
hoping someone might know, or at least if this is even possible.
'$Sheet2.$A$1'
INDEX($Sheet2.$A$1)
LOOKUP($Sheet2.$A$1, $Sheet1.$A$1:$Sheet1$A$10)
$Sheet1.'$Sheet2.$A$1'
Did you already try to leave out the sheet name?
A simple $A$1 as condition works on cell A1 of the sheet where the
conditional formatting is located.
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
