Counting Conditional Formats

  • Thread starter Thread starter kctony01
  • Start date Start date
K

kctony01

For example, I have a list of data under the conditional formats in excel,
for instance, sales figure with icon sets display in the conditional formats
settings. I would like to know if any of you know how I can count how many
greens, yellows and reds in each column of data?

I would prefer not to write formula using COUNTIF function because sometimes
I need to deal with data set that has at least 5 conditional formats.
My data set is very large and it is very unlikely that I can count that
manually.

Please help~
 
Think you could set-up a helper col to replicate the flagging of the 5
underlying conditions in the CF, returning simple flags such as: A,B,C,D,E.
Then just countif as desired on that helper col, or, create a pivot on that
helper col, with its col header placed in both the ROW and DATA areas - it's
a fast way.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
 
Back
Top