Excel 2007 conditional formatting

I am tasked with producing a workload tool...and I am having an issue getting Excel conditional formatting to cooperate. I have notated the attached spreadsheet with the changes I am trying make. Thanks!!
WorkloadDistributionForm.xlsx
singleton2787Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
barry houdiniConnect With a Mentor Commented:
With formulas, see attached

regards, barry
WorkloadDistributionForm-barry.xlsx
0
 
barry houdiniCommented:
I'm not sure you can do that with icon sets because you need to have the traffic lights in order, green is either at one end or the other.......it can't be in the middle - you could do it with ordinary cell formatting without the "traffic lights" is that any good?

regards, barry
0
 
Cory VandenbergSenior Risk ManagerCommented:
The ability to customize icon sets was added for Excel 2010.  I know that might not help you, but just wanted to let you know.  Without the use of imbedded images and code to handle which one to display, I'm not sure there is a way to do what you want in 07.  I would go with Barry's solution, unless there is some special need for the traffic lights.

WC
0
 
singleton2787Author Commented:
Is there a way to collapse the Days of the week (for easier readability as data is added)?
0
 
Cory VandenbergConnect With a Mentor Senior Risk ManagerCommented:
You can Group rows from the Data Ribbon.

I've updated Barry's solution to show an example.

WC
WorkloadDistributionForm-barry.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.