Count by highlighted color

  • Thread starter Thread starter Brandy
  • Start date Start date
Not as easily as you think. Out of 16 million colors
hope that means the one that actually is yellow. #FFFF00

It is not a good idea to do this. Much better would be to
use some criteria on the worksheet. And you could filter
on value with Filter or AutoFilter, but for what you asked...

See some examples at
Setting Interior Color based on another Cell (#popbased)
http://www.mvps.org/dmcritchie/excel/colors.htm
and pick up the actual functions to use at Chip Pearson's page
http://www.cpearson.com/excel/colors.htm

Now if the color was set or overridden by Conditional Formatting
it would be best to use the same formula you used for C.F.
rather than working through the Conditional Formatting formulas.
 
Back
Top