Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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
0
singleton2787
Asked:
singleton2787
  • 2
  • 2
2 Solutions
 
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
 
barry houdiniCommented:
With formulas, see attached

regards, barry
WorkloadDistributionForm-barry.xlsx
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 VandenbergSenior 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now