Lock cells based on color generated by conditional formating

[flashgordie]

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!

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
172	*	*	*	*	*	*	*	*	*	*	*	*	*
173	*	Slots	Available	Park1	Park2	Park3	Park4	0	0	0	0	0	0
174	Sunday	*	3	*	1	2	*	*	*	*	*	*	*
175	Monday	*	0	*	*	*	*	*	*	*	*	*	*
176	Tuesday	*	2	1	1	*	*	*	*	*	*	*	*
177	Wednesday	*	0	*	*	*	*	*	*	*	*	*	*
178	Thursday	*	2	1	*	*	1	*	*	*	*	*	*
179	Friday	*	0	*	*	*	*	*	*	*	*	*	*
180	Saturday	*	0	*	*	*	*	*	*	*	*	*	*
Calculations

 

[Von Pookie]

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?

You don't. Have the code lock a cell based on the condition(s) that cause the coloring.

 

[flashgordie]

Thanks for the advice. That would be an approach I have not investigated.
I will see if I can make that work, however, I believe there may be too many variables for me to hand, and for them to be applied against each cell.

Thanks for the reply!!