[Webinar] Streamline your web hosting managementRegister Today

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

Have the information on the "B" and "C" column displayed/input on the third box

a. Have the information on the "B" and "C" column displayed/input on the third box as follow.

All TODAY with (RED) Font Color

All TOMORROW with (YELLOW) Font Color

All FUTURE DAYS with (L/BLUE) Font Color

1st.png28980601a.xlsm
0
Omar Hernandez
Asked:
Omar Hernandez
  • 2
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
No green? BTW you should let people know what the password is.
0
 
Omar HernandezAuthor Commented:
Password is Omar, sorry forgot about that part.

Green is not needed, remember that those three color will be only for a specific date group

For TODAY, anything for today will be (RED)
For TOMORROW, anything for tomorrow will be (YELLOW) and
For FUTURE DAYS, anything for future days will be (LIGHT BLUE)
0
 
Martin LissOlder than dirtCommented:
Here's a version with code to handle the Must Do items. It also contains some bug fixes.

If this works OK then I have a question for you; shouldn't overdue tasks appear in either or both the "Every Now & Then" or "Must Do" shapes? If yes then please ask a new question after this one is closed, and I'll work on it while you are away.

Another small question; do you still want the "Num" button to display "Number is Completed" when it's done?
28981182.xlsm
0
 
Omar HernandezAuthor Commented:
Works like a charm, thanks again.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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