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.
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" <[email protected]> wrote in message
news:[email protected]...
>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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks