AnsweredAssumed Answered

Conditional formatting needs to prompt for a value

Question asked by mdallie on Aug 21, 2013
Latest reply on Aug 22, 2013 by philmodjunk


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.