Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Questionable
 
Posts: n/a
Default How do you shade in an unlocked cell on a protected worksheet?

If you have protected a worksheet, how can you highlight an unprotected cell
on that worksheet?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Are you Dave?

You could use Format|Conditional formatting.

Select your range (I used A1:X99)
then with A1 the active cell
Format|conditional formatting
formula is: =CELL("protect",A1)=0

Format it nicely.

If you're Dave, you have a response at your first version of this post.

Questionable wrote:

If you have protected a worksheet, how can you highlight an unprotected cell
on that worksheet?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"