Coloring rows according to date in a column

[3nduranc3]

Hello,

I was thinking of an inputbox, which has a current date + 2 weeks prefill when you start it, but you could change it if you like, and when you push ok, then it would color whole a certain area of a table, according to this value.

Just simple filter setting would do the work, but I actually don't know how to put a current date + 2 weeks filter on a column. Could you help me? And the range selected is not supported. Many things are missing here, i guess:

Please Login or Register  to view this content.

[3nduranc3]

Please Login or Register  to view this content.

I'm sorry. I did input some wrong code. Actually, most of it works, now I just don't know how to set a predefined date when the message box pops up, and how to formulate the date + 2 weeks.