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