Conditional formatting needs to prompt for a value
I've got a situation where I am printing a report and I have a date field and a text field with each record. I run this report and send it to a client every two weeks.
I need to have the text field highlighted in yellow if the date field is greater (newer) than the last time I ran the report. I haven't done it (new at this conditional formatting) but I assume I can figure out the concept of a formula that says, for example, if datefield > 8/7/2013 then make background of the text field yellow. What I'd like to do, though, is have the date be external to the conditional formatting formula so I don't have to go in and change the formula every time I run the report. I would like it to either be prompted for the date, or perhaps I can put it in some external location.
Any help would be sincerely appreciated. I've not used conditional formatting at all before and this is a pretty critical requirement.