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?