Can you use format|conditional formatting?

If yes...

Select A1
then select all the cells (A1 will be the active cell)
format|conditional formatting
formula is: =CELL("Protect",A1)=0
Choose the format you like for unlocked cells.





mikeburg wrote:

Need simplest VBA that sets the color of data entered in an unprotected
cell to blue & resets it back to automatic (black) when & if a cell is
protected again.

The data may or may not be already entered. Therefore, the change
should take place when a cell is either unprotected or protected (not
when sheet protection is turned on or off).

I prefer not having to put the VBA code in every worksheet but have it
for all workbooks & worksheets.

Any ideas?

Thanks so much for your help. mikeburg

--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=489272

--

Dave Peterson