can I use the sumif function with cell formatting as the criteria

[Dean]

I want to be able to add the values in a column of cells based on the color
formatting of that cell as the criteria. Is there a way to do that with
sumif or is there some other function that will do that?

 

[Shane Devenshire]

Hi,

You can't use any of Excel's functions to sum based on color unless the
color is itself applied based on a condition which you can enter in a regular
formula. You can write a VBA function to sum based on color.