Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Have "L" column display the task, dates and color on the second box.

Hello there Expert Exchange community,

---Wanted to have any assign task with dates that are from the "L" column on the second box that is located on the page called (SHEET 1)
---Please have all of the task shown in groups of color ( for example; if i have task for today shown on the (GENERAL SHEET)
1 yellow
2 red
1 blue
1 green
1 yellow
1 green

Have them appear  All Green being on top of all color then all red, then all blue and last all yellow.

2 green
2 red
1 blue
2 yellow

Same theory with the Tomorrow and Future Days group.

Second box will be displaying all task that have the task in three separate rows.  


****TODAY***** = Only task that are schedule for today.

****TOMORROW**** = Next day

****FUTURE DAYS****  = Days that does not includes today or tomorrow but task that are assign in two days from now and further on.

1st.png28974603b.xlsm
0
Omar Hernandez
Asked:
Omar Hernandez
  • 11
  • 11
1 Solution
 
Martin LissRetired ProgrammerCommented:
The workbook you attached has just the GENERAL worksheet. The other two are missing.
0
 
Martin LissRetired ProgrammerCommented:
It's a workbook from some time ago.
0
 
Omar HernandezAuthor Commented:
sorry about that, here you go Marty
28980395.xlsm
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Martin LissRetired ProgrammerCommented:
Is the password still "Omar"?
0
 
Omar HernandezAuthor Commented:
yes
0
 
Martin LissRetired ProgrammerCommented:
I'd like to use a feature that is only available in Excel 2010 and later. Is that a problem?
0
 
Omar HernandezAuthor Commented:
sounds good
0
 
Martin LissRetired ProgrammerCommented:
I've run into a problem and that is that while I can manually color a part of a shape, I need to find out how to do it programmatically.
0
 
Omar HernandezAuthor Commented:
is it possible Marty to have the (NUMBER BUTTON) to when there is a color used for a task have the title of the color input to column "O" for example on task on date "10/31/16 WHY IS IT IMPORTANT TASK"

It to displaying in "RED" to help it differentiate it from the total of four color have it input in column "O" word (RED)

When the second box located in (TO DO SUMMARY) have it go through first as a bridge to the "O" column find the color it will be display and get the rest of information of the due date and task name.
0
 
Martin LissRetired ProgrammerCommented:
I think I may have solved the problem.
0
 
Omar HernandezAuthor Commented:
nice
0
 
Martin LissRetired ProgrammerCommented:
Yeah you pound away at something long enough you can beat it into submission:)
0
 
Omar HernandezAuthor Commented:
ha ha,, lol
0
 
Martin LissRetired ProgrammerCommented:
Try the attached. The list shows up when you refresh. Currently it's a little slow because I'm looking at the data on the GENERAL sheet 8 times (2 periods x 4 colors = 8). I may be able to speed it up but I want to make sure that what I've done so far is what you want.

I changed the color of one of the shapes so that the blue todo's can be read.
28980601.xlsm
0
 
Omar HernandezAuthor Commented:
Looks very good, only have two things to have to make it right on point, but as i  said so far looks awesome.

1st.png
0
 
Martin LissRetired ProgrammerCommented:
I can do green first. Is the desired order green, red, blue, yellow?
0
 
Omar HernandezAuthor Commented:
yes
0
 
Omar HernandezAuthor Commented:
any luck my friend
0
 
Martin LissRetired ProgrammerCommented:
I thought you might be wondering:) I'm still working on it. It's very tricky.
0
 
Omar HernandezAuthor Commented:
yes i had a felling it would have been one of those moment with this function. Thanks for always making it possible with previous question and looking a way around the challenging task.
0
 
Martin LissRetired ProgrammerCommented:
Here you go.
28980601a.xlsm
0
 
Omar HernandezAuthor Commented:
Really neat wrapping up the end result, thanks again Marty appreciate your expertise
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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