Cell manipulation

G

Guest

Looking to have certain cells ( where lock=false ) to have yellow background.
Else, standard white background.

This should allow me to run macro whenever I want, in the event that cell
locking
or unlocking was changed.
Assuming this would be a macro, for ease of use, I would prefer to be able
to operate this from a button on my custom personal macro toolbar.

John F. Scholten
 
D

Dave Peterson

Are you using format|conditional formatting for anything on that worksheet?

If no,
select A1
hit ctrl-a (twice in xl2003)
format|conditional formatting
formula is:

=CELL("protect",A1)=0

format nicely (Pattern tab)
 
G

Guest

Dave:
Not quite what I had in mind.
Thanks for your response.
Sorry for posting this on programming group.
I have "moved" it to new user - more appropriate, I think.

John F.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell colour if..... 6
conditional format - table - cell empty return default color 1
Roundup Nesting 13
Macro for cell colors? 2
Concantenate All cells in Row left of current active cell-- 8
Add Borders based on ByVal Target As Range 5
If then else, or select case is giving me a problem 3
Excel Run macro upon cell edit 0

Top