Event when font color changed

[Axmed.cm]

Dear all

Could anyone help me change this vba worksheet_selection_change event to when font color in range("A1:A12") is changed.
the code is here

Please Login or Register  to view this content.

Thanks

[cytop]

There is no Font Changed event... and the code posted simply changes the colour if it is Red, regardless...

[TMS]

What cytop said .

If you are trying to count, or sum, coloured cells, you could use AutoFilter to filter column A based on the background, or font, colour. And you can use SUBTOTAL to count or sum the values in the visible cells.

Doesn't need VBA.

[Axmed.cm]

Thank you cytop an TSM.

I want to manually change the fonts to red.
Then I need cell A13 to sum red color cells automatically.

This code updates when the select another cell after font color changed

If there no nearest way I will use my own

Thanks

[TMS]

Have a look at this site: http://www.cpearson.com/excel/colors.aspx

[Axmed.cm]

Thanks TMS