conditionally highlight unprotected cells
 

Is there a way in Excel 2007 to automatically highlight or format all
unprotected cells?

conditionally highlight unprotected cells
 

hi, Bob !

Is there a way in Excel 2007 to automatically highlight or format all unprotected cells?

try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.)

=cell("protect",a1)=0

hth,
hector.

conditionally highlight unprotected cells
 

Thanks, Héctor, that works great!

"Héctor Miguel" wrote:

hi, Bob !

Is there a way in Excel 2007 to automatically highlight or format all unprotected cells?

try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.)

=cell("protect",a1)=0

hth,
hector.

conditionally highlight unprotected cells
 

Thanks, Héctor, that works great!

"Héctor Miguel" wrote:

hi, Bob !

Is there a way in Excel 2007 to automatically highlight or format all unprotected cells?

try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.)

=cell("protect",a1)=0

hth,
hector.