Conditional Format for cell protection?

Giganews Newsgroups
Subject: Conditional Format for cell protection?
Posted by:  Scott (esky…@telusplanet.net)
Date: Thu, 13 May 2004

Hello, Can anyone tell me if theres a way in Ex2000 to use conditional
formatting to set whether a cell is protected or not?.  IE if a certain
condition is met then set that cells format-protection to locked. I know
how to set its font/color etc under certain conditions but seems to me
you should be able to set protection as well

If not I think it would be a good addition in conditional format
options, dont u think Mr Gates?

Replies