Hi there,
I need to count the number of cells that are shaded a particular colour.
For example, if five cells in a worksheet are coloured pink, then the value should show 5.
Is this possible? Please help.
Thank you
Hi there,
I need to count the number of cells that are shaded a particular colour.
For example, if five cells in a worksheet are coloured pink, then the value should show 5.
Is this possible? Please help.
Thank you
Hi,
These links might help
http://www.cpearson.com/excel/colors.htm
http://www.xldynamic.com/source/xld.ColourCounter.html
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks