conditional fortmat formula for unlock

[var]

hi there

if C1 is unlocked, A1 must change color. I'm made few unsuccessful attempts by using


=CELL("PROTECT",C1)=0

what am I doing wrong??


thanks-var

[Leith Ross]

Hello var,

I had no problem applying your format condition as written. Perhaps you should post your workbook.

[var]

Hi Leith

I just found that, color change is not happening immediately but if close and open the file I see change in color. Why is that delay. thanks var

[Leith Ross]

Hello var,

It worked as you wrote it in my Excel 2003 workbook.

1. Are you doing a lot of calculations with formulas?
2. Is calculation mode set to automatic?
3. Is the worksheet protected?

[var]

Hi Leith

I sue 2003 too..

1) Not many calculations,
2) I need check auto calculation mode, is that in tool/settings
3) Not protected

thanks-var

---------- Post added at 03:42 PM ---------- Previous post was at 03:35 PM ----------

Hi Leith

I use 2003 too..

1) Not many calculations,(in fact nil)
2) its in auto calculation mode..(tools/options)
3) Not protected

thanks-var