Multiple Conditional Formats

[tomwood123]

Hi
I am trying to put some names into excel to create a histogram. I have everything inputted but I want the colours in the cells to change depending on the job role, i have a couple of rules but cannot seem to get the rule to do a formula that makes the colour change depending on the job role.

Can anyone help please? I'm sure its very simple....

 

[lennywatson]

Can you clarify a little:
-What does the histogram show? (is there data associated with the names to display by histogram?)
-Do you have cells with names in them, and you want those cells to change colors? If so: Do the names have fixed job roles, or do people take on different jobs in different places on your sheet? If they change jobs, what part of the sheet indicates which job they are doing?

 

[tomwood123]

Thanks for your response. The histogram is showing how many people are working on a project. We have a team of people so want to show graphically who is working on what and how busy they are each week. There are two columns (1 is role, 1 is the person). So for example Estimator, Bob Smith. Then we want the bar colour to change depending on the role. So all Estimators will highlight red for example...bid managers blue.....admin green and so on. Would it be possible to send you the sheet so you could look at this? I think it is something to do with conditional formatting but I cannot seem to get it to work.