View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Billparsons40 Billparsons40 is offline
external usenet poster
 
Posts: 1
Default How can I protect only cells that meet certain conditions?

I want to allow users to enter a value in a cell (say G5) only if another
cell (G21) has a value greater than zero.

If G21 is zero or blank, then I do not want the user to be able to select G5.

This is for Microsoft Xcel 2000.