Using a Macro with a check box to Change a cell color

[avi8or54]

I'm not very good with macro's, but what I'm trying to do is: I have
start date and an end date, and specific actions that must b
accomplished against the start date. (i.e. aircraft goes in o
10/24/2004 and 10 tasks must be accomplished prior to input, I want t
be able to change a cell to red, yellow, or green depending on how man
boxes are checked against the input date.) Any help would be greatl
appreciated

 

[Bob Phillips]

Depends on where you source the checkboxes from, and what combinations
generate a colour, but here is a start using control toolbox checkboxes

Dim cnt As Long

With ActiveSheet
cnt = -(.CheckBox1.Value + .CheckBox2.Value + .CheckBox3.Value)
.Range("A1").Interior.ColorIndex = WorksheetFunction.Choose(cnt, 3,
6, 10)
End With