ExcelBanter - convert higlighted days inexcel calendar to value, then sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - convert higlighted days inexcel calendar to value, then sum (https://www.excelbanter.com/excel-worksheet-functions/199322-convert-higlighted-days-inexcel-calendar-value-then-sum.html)

Twishlist

convert higlighted days inexcel calendar to value, then sum

I have an excel calendar on which I have highlighted particular dates. I
would like a formula that looks at the range and counts the cells that are
highlighted yellow, then multiplies that number by a x hours.
Is that easy to achieve?

David Biddulph[_2_]

convert higlighted days inexcel calendar to value, then sum

Can't do it by a formula. Needs VBA.

http://www.cpearson.com/excel/colors.aspx gives some examples of how to use
VBA for cell colours.
--
David Biddulph

"Twishlist" wrote in message
...
I have an excel calendar on which I have highlighted particular dates. I
would like a formula that looks at the range and counts the cells that are
highlighted yellow, then multiplies that number by a x hours.
Is that easy to achieve?

All times are GMT +1. The time now is 03:10 PM.