1) I have a 'to-do' list with a column of 'date due' (column D)... I need to set up conditional formatting on that column so the things that are past due are red, due today are green, due tomorrow are yellow.
2) And the column 'E2 and on' next to that has 'not started/pending/complete' when...
Haseeb A, Thank you so much! Works perfect!
I'm just getting started with Excel and working on my to-do/goals spreadsheet which will have some about learning more about excel.
You're awesome! Thanks again.
I have a basic 'to-do' list and I want to see how many of my tasks are due today, tomorrow, this week, this month, and this year.
Project Description Due Date Status
Learn Excel Learn Excel Tables 10/18/12 Pending
Learn Excel Learn Excel Sparklines 10/19/12 Pending
Learn Excel Learn Excel...