flashgordie
Board Regular
- Joined
- Jan 9, 2008
- Messages
- 97
- Office Version
- 365
- Platform
- Windows
I have searched through the site, and have found many similar items regarding the locking of cell, but nothing that is quite the same.
I have a small chart. The cells in the chart are formatted using conditional formatting.
Depending on the values of cells on the x axis (Park Names) and y axis (time Slots), the colour of the intersecting cell will be orange or purple.
If the cell is orange, I would like to allow the user to input a number in the orange cell, however if a cell is turned purple, I would like to lock the cell so the user can not enter any information. The orange color is generated if there is both a "park" and a "timeslot". If there is no park and/or there is no time slot, the cell should be purple and thus be locked.
How do you lock a cell based on the colour that is generated by the conditional formatting generated by the values of the other two other cells?
Thank you!
I have a small chart. The cells in the chart are formatted using conditional formatting.
Depending on the values of cells on the x axis (Park Names) and y axis (time Slots), the colour of the intersecting cell will be orange or purple.
If the cell is orange, I would like to allow the user to input a number in the orange cell, however if a cell is turned purple, I would like to lock the cell so the user can not enter any information. The orange color is generated if there is both a "park" and a "timeslot". If there is no park and/or there is no time slot, the cell should be purple and thus be locked.
How do you lock a cell based on the colour that is generated by the conditional formatting generated by the values of the other two other cells?
Thank you!