Make a cell grey and locked

[SFFliberte]

Let's say I have A1 linked to a checkbox. If A1=TRUE I want B1 to be grey and locked. If A1=FALSE I want B1 to be white and unlocked.

Please help. . . . thank you

[teylyn]

Hi,

could you please take a moment to read the forum rules and then remove the superflous words from your thread title?

You need to link the state of the checkbox to a cell and then you can do conditional formatting of another cell based on the value in the cell linked to the check box.

Depending on what kind of check box you have:

Control Toolbox checkbox:
switch on development mode, right-click the check box and select properties. In the LinkedCell property enter A1

Form check box:
right click the checkbox and select Format contro, go to the Control tab and enter A1 in the Cell link box

this will now show TRUE or FALSE in A1 if the box is ticked or not.

Use the custom format ";;;" to hide the values

now you can conditional format another cell with

Formula is:

=A1

Note that with conditional formatting you can only change the color of the cell, font, border, you can not change the protection status. That would require VBA