Is there a known issue with using logical operator functions with
conditional formatting?

The reason I ask is that I have a long conditioning formula (for cell 'F5'),
which works fine (ie it obeys the formatting request).

=OFFSET($CH$1,ROW()-1,MATCH(LEFT(F$1,2)&" Class",$CI$1:$DP$1,0))<""

However, when I change it to

=OR(TRUE,OFFSET($CH$1,ROW()-1,MATCH(LEFT(F$1,2)&"
Class",$CI$1:$DP$1,0))<"")

it no longer works (ie it no longer obeys the formatting request).


Of course, my actual aim is not just to 'OR' with the TRUE constant, I've
just reduced my problem down to the minimal level for diagnosis and now
don't know where to go.

Any help much appreciated.

Thanks

GB

Oh yes and one other question: Is there any way to enable cursor movement in
the conditional formatting dialog box without it changing the formula?