PC Review


Reply
Thread Tools Rate Thread

Conditional Format To Lock Cell

 
 
james@smooth-tech.com
Guest
Posts: n/a
 
      1st Nov 2007
Hi,

I run some forecasting sheets for my work using excel, and have come
across a problem.

Basically there are multiple columns with each customer, and multiple
rows with week 1 to week 52. The people in charge of forecasting must
finalise their predictions 5 weeks in advance. I have written a
conditional formula that makes the cell grey if that cells date is
less than 5 weeks away. However I would really prefer to have this
cell locked, and passworded.

Is there any way of doing this?

Additional information:

The first cell this applies to is T11. (down to T62) Then rows Z, AF,
AL etc all way until ED.

Thanks in advance,

James

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock cell formats (conditional format) Saintsman Microsoft Excel Worksheet Functions 1 8th Jan 2008 05:12 PM
lock cell conditional format but not restrict data entry =?Utf-8?B?R0FN?= Microsoft Excel Worksheet Functions 1 18th Aug 2007 06:53 AM
conditional lock format Elfego Baca Microsoft Excel Discussion 2 27th Mar 2007 04:29 PM
Re: How lock cell format, but not lock cell contents? Dave Peterson Microsoft Excel Worksheet Functions 2 10th Sep 2003 03:17 AM
How lock cell format, but not lock cell contents? Gavin Microsoft Excel Worksheet Functions 0 9th Sep 2003 09:35 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:28 AM.