You could presumably simplify that to =([target_cell]="TRUE"), or go another
step and get the formula in the target cell to produce a logical, rather
than a text string "TRUE", and then you could just have =[target_cell] ?
--
David Biddulph

"strawberry" wrote in message
oups.com...
....
In answer to the first part, the way I'd do it is to have cell
somewhere else (perhaps on another worksheet) that only evaluates to
true if all the conditions are met and then point the conditional
format to that cell like this:
=IF([target_cell]="TRUE",1,0)