How to get color to fire an event code?

[southernsquid]

Hi,
Does anyone know how to get a fill color to fire an event code and add a value? Thanks

 

[VoG]

Sorry, no event is triggered when a fill color is changed.

 

[southernsquid]

Thanks for the reply. I understand it doesn't fire a code. Is their a macro that can make this work? I found this one on the internet but don't know enough about macros to see if it works. Please help. Thanks

Sub mahdi()

If Sheet1.Cells(1, 1).Interior.ColorIndex = 3 Then 'Red Color
Sheet1.Cells(1, 1).Value = 1
End If

If Sheet1.Cells(1, 1).Interior.ColorIndex = 10 Then 'Green Color
Sheet1.Cells(1, 1).Value = 2
End If

End Sub

 

[VoG]

That will change the value of A1 depending on the fill color. It doesn't work automatically - you have to run the macro.

Perhaps explain what exactly you are trying to do.

 

[southernsquid]

I'm trying to track requirements for a bunch of people (military). My spreadsheet basically has members down the side with tasks along the top. We are filling cells for members as they complete the tasks. I would like to get percentages of completion by member and by task, but I can't because there is no value to average when you use a color. An alternate would be to use an X and have a value for it. Is that possible? Thanks

 

[VoG]

Try this http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

 

[southernsquid]

thanks VoG. Feels like I'm learning through a fire hose but I will figure it out. Thanks again