Hello,
Is it possible to create a criteria based formula in excel 2003 that uses cel formatting as a criteria? (without the use of VBA)
For example, i have a list of values which all have different cell fill colors.
1 (green cell fill)
3 (yellow cell fill)
5 (blue cell fill)
9 (green cell fill)
2 (yellow cell fill)
Is there a formula that can do the following:
sumif cell fill is green = 10
sumif cell fill is yellow= 5
Thanks a bunch for your help!
Alex
Is it possible to create a criteria based formula in excel 2003 that uses cel formatting as a criteria? (without the use of VBA)
For example, i have a list of values which all have different cell fill colors.
1 (green cell fill)
3 (yellow cell fill)
5 (blue cell fill)
9 (green cell fill)
2 (yellow cell fill)
Is there a formula that can do the following:
sumif cell fill is green = 10
sumif cell fill is yellow= 5
Thanks a bunch for your help!
Alex