conditional format + Date

Hello, have a further ask from yesterdays questions. can anyone give me a clue as to how to generate a pop up box that asks the user if they want to enter todays date then uses that date they enter to make the calcuations to work out 3 days ago and highlights all text that relates to the rows that have dates three days ago.
idea being the sheet musnt be dynamic an auto update, otherwise each time a user opens it the highlighted cells will change, and i need them static once set. its for a reportign tool that captures aged cases of 4 days or more.

many thanks Keivn

Hello again kkinsella,

You could do that..... but why not just manually set up conditional formatting for the column and then have your users type in the relevant date into a cell on the worksheet?

So for example. select column E, go into format--> conditional formatting, insert this formula
=AND(ISNUMBER($E1),$E1<$A$1-4)

So your users update the cell A1 with the date they want to use. This date feeds the conditional formatting. I just think this is much simpler.... much less that can go wrong. Does it suit you?

HTH
Colin

Colin, once again you make it look so simple but supply a splendid answer, thanks again saved me hours of messing around :-)