reminder on excel

[pablojara90]

hi guys,
So I'm trying to create a worksheet that would work kinda like a reminder. One cell would have the current date so every time I open it it will show my the current date.... possible??
in one column I would add the dates that the tasks are due, and if the due date is the same as the current date that row, which would have all the additional information, will be colored, say, red. I will also have a column where I would write if a task is in progress or not. and if that task is in progress then that row will be colored in a different color.
can someone help me please??

PS: sorry for my English, It isn't my first language but I tried my best. I hope I make sense

 

[wrightyrx7]

You can do this with normal conditional formatting.

Select you column with the dates and go to conditional formatting.

Rule 1 = "Blanks" " No Formatting" TICK the Stop if true
Rule 2 = "Cell Value" "Less than or equal" "=now()" (format this red or something)

Hope this helps

 

[Smitty]

Welcome to the Board!

wrightyrx7 has you covered on Conditional Formatting, but for today's date you can use =TODAY(), which will update to today's date when the workbook is opened.

HTH,

 

[pablojara90]

thank you for the quick response, one more question... what you did will only change the cell but how do I make the row to change?

Pablo