I have cells with diffent color fonts and need to total based on .
I need to total a range of cells in excel based on the font color. I assume
this would be done with an "IF" statement but how do I word it? I want to total cell range C8 to AG8 but only if the font color is Blue. |
Hi Kyara
this is not possible without using VBA ... see http://www.cpearson.com/excel/SortByColor.htm for details. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "KyaraB" wrote in message ... I need to total a range of cells in excel based on the font color. I assume this would be done with an "IF" statement but how do I word it? I want to total cell range C8 to AG8 but only if the font color is Blue. |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com