Is there a way in Excel 2007 to automatically highlight or format all unprotected cells?
B Bob Arnett Mar 21, 2008 #1 Is there a way in Excel 2007 to automatically highlight or format all unprotected cells?
H Héctor Miguel Mar 21, 2008 #2 hi, Bob ! Is there a way in Excel 2007 to automatically highlight or format all unprotected cells? Click to expand... try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector.
hi, Bob ! Is there a way in Excel 2007 to automatically highlight or format all unprotected cells? Click to expand... try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector.
B Bob Arnett Mar 21, 2008 #3 Thanks, Héctor, that works great! Héctor Miguel said: hi, Bob ! try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. Click to expand...
Thanks, Héctor, that works great! Héctor Miguel said: hi, Bob ! try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. Click to expand...
B Bob Arnett Mar 21, 2008 #4 Thanks, Héctor, that works great! Héctor Miguel said: hi, Bob ! try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. Click to expand...
Thanks, Héctor, that works great! Héctor Miguel said: hi, Bob ! try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. Click to expand...
