Release of Cell Protection?

G

GBL

Hi:
Got a problem attempting to re-format a few cells to a different color\fill.
I've checked Tools\Format\Cells\Protection and the setting are blank; but I
can't get rid of or change the "fill" colors. Can anyone help?
Thanks in Advance!!
 
P

Paul B

GBL, the cells might have data validation on them, check and see if that is
the case
 
G

GBL

Hi Paul:
Thanks for the hint. It put me on the correct path. I had used Contitional
Formatting; which was the problem.

Paul B said:
GBL, the cells might have data validation on them, check and see if that is
the case

GBL said:
Hi:
Got a problem attempting to re-format a few cells to a different color\fill.
I've checked Tools\Format\Cells\Protection and the setting are blank;
but
 
P

Paul B

GBL, that is what I was thinking of, don't know why I put validation!, must
have been a Monday!!
GBL said:
Hi Paul:
Thanks for the hint. It put me on the correct path. I had used Contitional
Formatting; which was the problem.
 

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

Top