singleton2787
asked on
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
WorkloadDistributionForm.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
WC
ASKER
Is there a way to collapse the Days of the week (for easier readability as data is added)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
regards, barry