|You could use Conditional Formatting to highlight cells based on a date entered in another cell. |
For example, if you had report names in Column A and dates in Column B, like shown below, you could enter a date in C2 and both the Report Name and Date would be highlighted.:
A B C
1 Report Name Due Date Date Request
2 Report A 11/22/2012 11/22/2012
3 Report B 11/23/2012
4 Report C 11/24/2012
5 Report D 11/22/2012
6 Report E 11/23/2012
7 Report F 11/24/2012
1 - Select A2:B7
2 - Use this Conditional Formatting rule and choose a fill color
Note: The placement of the $ are based on the example shown so that the CF will be applied to entire range correctly.
When you enter a date in C2, the Report Name next to the Date that matches C2 will be formatted with your fill color. The Due Date will also be highlighted.
If you are looking to extract a list of reports due to another location, it is a bit more complicated and we would need to know a little about your data layout, like the example I posted above.
Please click on the following line and read the instructions found via that link before posting your data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.