Combining INDIRECT with OR for use in conditional formatting

Hi all,

this might seem like a simple question to some of the more experienced users but here 'tis...

I'm using conditional formatting with a formula to highlight certain rows where a column contains a specific piece of text, for example:

Please Login or Register  to view this content.

What I'd like to do is check for several different pieces of text and so I thought that using an OR statement might help - thing is, I don't know whether to put the OR before the INDIRECT, or vice versa - I've tried both ways but I guess I must be leaving out a comma or parenthesis (or something) because it's not working the way I would like.

This what I've been trying...

Please Login or Register  to view this content.

Any ideas on what I'm doing wrong here?

Cheers,

AJ

Hi,
Perhaps

=IF(OR(INDIRECT("C"&ROW())="Text 1",INDIRECT("C"&ROW())="Text 2"),"then this","if not that")

tRY:

=OR(INDEX($C:$C,ROW())="Text 1",INDEX($C:$C,ROW())="Text 2")

INDIRECT is volatile, INDEX is not volatile.