Release of Cell Protection?

  • Thread starter Thread starter GBL
  • Start date Start date
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!!
 
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;
Click to expand...
but
Click to expand...
 
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.
Click to expand...
 
Back
Top