conditional format
 

trying use diff., worksheet as the ref.,
exp. =not('worksheet2'b6=0)
This will not work unless exist within the same worksheet.
Is there a way to work aound it?

conditional format
 

See answer in other group.
Please do not multipost -- most people read all the newsgroups
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"djc" wrote in message
...
trying use diff., worksheet as the ref.,
exp. =not('worksheet2'b6=0)
This will not work unless exist within the same worksheet.
Is there a way to work aound it?