Formula Question
Is there a way I can take dates from one worksheet and have them highlight the appropriate dates on a calendar worksheet? If so, can anyone tell me how?
|
Quote:
The simplest way to name a range is to click on the cell containing the date on the first sheet you are checking for, and in the Name Box in the top left corner of Excel (where it says, for example, C3) type in a name (e.g. InputDate) and press Enter - no spaces allowed in the name. Then your Conditional Format formula for the range of dates in the second sheet would be: =IF(A2=InputDate,TRUE,FALSE) ...where A2 is the location of the first date you want to check. Remember to give it some formatting (e.g. highlight in yellow). Copy this formatting across the range of dates you want to interrogate on the second sheet. |
All times are GMT +1. The time now is 03:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com