Thread: Conditional Formatting to Indicate Start Date & End Date

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.

It isn't really clear what exactly you want highlighted.

If you want to color cell in the monthly sheets based on date entered in Main sheet... then.

first name the range in Main, select A4:C17 and name it: e.g. DataRange

Then in Nov11 sheet, select the range from B5:AE18 and apply conditional formatting, Home|Conditional Formatting|New Rule

Select use a formula to determine which cells to format and enter formula:

=VLOOKUP($A5,DataRange,2,0)=B$4

Click Format and choose yellow from Fill tab.

Click Ok.

Click New Rule and repeat above with formula:

=VLOOKUP($A5,DataRange,3,0)=B$4

The 2 and 3 are column index numbers.. i.e. the column within the DataRange you want to extract. The 0's mean look for exact match...

Have a look at VLOOKUP in help file (note 0 is equivalent to FALSE, for finding exact match)