Hi,

Put a checkbox from the 'Forms' toolbox on your sheet. Right click is and
apply this macro

Sub CheckBox1_Click()
If ActiveSheet.CheckBoxes("Check Box 1").Value = xlOn Then
Range("A1").Interior.ColorIndex = 3
Else
Range("A1").Interior.ColorIndex = xlNone
End If
End Sub

Change the range and colour to suit your requirements.

Mike

"dazoloko via OfficeKB.com" wrote:

Dear All

Is it possible to colour a range of cells based upon a check box ie if it is
checked, a particular range is green or if its unchecked the range is red ?

Thanks in anticipation

D

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1