Hi All,
I'm trying to setup a schedule tracker while monitoring contract start and expiry date.
Previously I received help but I did not understand how the formula used
"=IFERROR(MATCH($A5&B$4,range1,0),0)>0" and could not get it to work on my entire workbook.
Sheet1 contains Names, Start Date, End Date
Sheet2 - SheetX contains Names, cells representing each day in a month
Please guide me on how to indicate Yellow for Start Date and Orange for End Date using Conditional Formatting. Thank you.
Bookmarks