frequency of formats

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

flipinoluv

Thread Starter
Joined
Apr 16, 2004
Messages
21
I have an excel work sheet that uses colors in a matrix of people and skills they posses.

along the y axis would be the people, along the x axis would be the skill.

i am denoting colors, green=skilled, blue=needs refreshment, red=not trained.

I need to tabulate how many skills each person has.

Is there a way to be able to count the number of times a color, (i.e green) box occurs in a row/column?
 

flipinoluv

Thread Starter
Joined
Apr 16, 2004
Messages
21
I am trying to add drop down menus so that the user can only choose from a basic set of colors so that there can be no mistake in counting by color by choosing another shade.

I found i was unable to create a drop down box that only included colors.

I found out a way around this using conditional formatting, substituting text and just making the text the same as the background color....

However, for some reason, the COUNTBYCOLOR will not count or change its value. For some reason, conditional formatting does not change the 'official' pattern style of the cell and therefore it wont register it as a change in color.

2 questions...

1) Is there a way around this?

2) How can I add more conditional formats?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top