Eric58132
02-24-2012, 01:09 PM
Hi everyone, always love this forum: Happy to report that I haven't stopped in nearly as frequently because I don't need assistance as often! Perhaps I should start responding to the inquiries of others, heh heh.
Anyway, my new company uses Excel 2010 (way better than the '03 at my former job), and I was asked to create a utilization dashboard for my team to task out our work.
What I'm trying to do is this: Use the 3-tiered coloring in Excel 2010's conditional formatting to change the color of each employee's weekly scheduled hourly workload, based upon the number of hours they can work in a week (taking the fact that they have holidays/vacation spread throughout the year into account).
Basically, I have a cell that lists each person's hours of scheduled work, and another that lists the total of hours they have available to work. I then have a percentage, based upon scheduled/available.
For example:
I have 10(cell A1) hours of scheduled tasks, and am only available to work for 24(cell A2) hours. The "percentage" cell reports this as 41%(cell A3). If I conditionally format this 41% on a 0-100% scale, with green being near 0%, yellow near 50% and red up near 100%, this would result in the cell being a yellowish tint. My question, is how do I get the yellowish tint from cell A3 to display in cell A1?
Anyway, my new company uses Excel 2010 (way better than the '03 at my former job), and I was asked to create a utilization dashboard for my team to task out our work.
What I'm trying to do is this: Use the 3-tiered coloring in Excel 2010's conditional formatting to change the color of each employee's weekly scheduled hourly workload, based upon the number of hours they can work in a week (taking the fact that they have holidays/vacation spread throughout the year into account).
Basically, I have a cell that lists each person's hours of scheduled work, and another that lists the total of hours they have available to work. I then have a percentage, based upon scheduled/available.
For example:
I have 10(cell A1) hours of scheduled tasks, and am only available to work for 24(cell A2) hours. The "percentage" cell reports this as 41%(cell A3). If I conditionally format this 41% on a 0-100% scale, with green being near 0%, yellow near 50% and red up near 100%, this would result in the cell being a yellowish tint. My question, is how do I get the yellowish tint from cell A3 to display in cell A1?