golf4
Active Member
- Joined
- Jul 8, 2002
- Messages
- 452
Hi, everyone -
I just had a quick query. Working on my income calculation tool, I ran into something I haven't tried before. First, my data entry sheet is fully protected, via password, except for cells I use to enter specific data for calculation.
What I'm wondering is what the best method is to accomplish the following (example): if cell A1 equals either 4 or 5, then how would I protect cell A2? I'm thinking it's got to be something like =IF(OR(A1=4,A1=5),PROTECT(A2),"")? Or could the same thing be accomplished in Conditional Formatting? Any help would be great.
Thanks,
Golf
I just had a quick query. Working on my income calculation tool, I ran into something I haven't tried before. First, my data entry sheet is fully protected, via password, except for cells I use to enter specific data for calculation.
What I'm wondering is what the best method is to accomplish the following (example): if cell A1 equals either 4 or 5, then how would I protect cell A2? I'm thinking it's got to be something like =IF(OR(A1=4,A1=5),PROTECT(A2),"")? Or could the same thing be accomplished in Conditional Formatting? Any help would be great.
Thanks,
Golf