Apr 20 2022 09:18 AM
what do you enter as the criteria in the sumif function when you want to sum only cells that are highlighted
Apr 20 2022 10:14 AM
If the cells are highlighted using conditional formatting, refer to the condition(s) of the conditional formatting rule instead of to the cell color.
If the cells have been colored manually, you'll need to use VBA: see for example http://www.cpearson.com/excel/colors.aspx
Apr 25 2022 01:05 PM
@Hans Vogelaar Thank you very much for you prompt assistance.