Highlighted Cell Date with Conditional Formating

[angela_n88]

Hi All,

I need help to use formula in Conditional Formatting to highlight cell (date) in the Calendar if an employee work on that date from the next sheet name - Pay 1.

I have tried to use this formula for cell C7 - MATCH(C7,'Pay1 B16:B69,0) but it works for only one cell. It did not work when I tried to copy that for D7:P7

Also, is it possible to MATCH C7 from Highlight sheet to match in range B16:B69 in Pay 1 sheet and IF M16>0.

Sorry if it is too much information. I have attached file for your help.

Much appreciated!

Sample.xlsx

[Kaper]

Wouldn't be just

Please Login or Register  to view this content.

enough?

and to take into account M16>0

Please Login or Register  to view this content.

[angela_n88]

Hi Kaper,
Thanks for your reply.
However, it does not work when I copy format cell C7 to cell D7:O7.
I mean when the date in Cell D7 is not highlighted when the date.
Also, I want to use MATCH and INDIRECT to reference to different spread sheets but it is not working.

Below is the formula for one spreadsheet name is in cell B7 but need to referent to different spreadsheets from B7:B32.

Much appreciated for your time and concerns

=IFERROR(INDEX(INDIRECT("'"&$B$7&"'!$B$16:$B$69"), MATCH(C7, INDIRECT("'"&$B$7&"'!$B$16:$B$69"), 0)), "Not Found")

[JeteMc]

The following seems to work for cells C7:O7

Please Login or Register  to view this content.

I feel that your INDIRECT formula will look like:

Please Login or Register  to view this content.

Let us know if you have any questions.