Share via

Employee Attendance Tracker

Anonymous
2018-12-28T17:46:36+00:00

I need to add a few more options for leave types. When I do this the number changes on the new leave type however the calendar dates do not become colored in. Is there a way to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-01-04T03:50:42+00:00

Hi bouyank557,

If you have concerns about Conditional formatting, here is an article for your reference: Use formulas with conditional formatting.

About the conditional formatting in the workbook you have, the formula is like this:

=COUNTIFS(lstEmpNames,valSelEmployee,lstSdates,"<="&C6,lstEDates,">="&C6,lstHTypes,'Leave Types'!$B$4)>0.

It means the date in the calender view that the selected employee has sick leave(cell B4 in the leave type sheet) will be colored like the preview:

If you want to set the new color for the leave types you add, you could use the similar formula and change the $B$4 to the cell reference of the leave type.

Regards,

Alex

Was this answer helpful?

0 comments

Answer accepted by question author

Anonymous
2019-01-02T00:09:32+00:00

Hi bouyank557,

Thanks for sharing. I test the new workbook. If you mean the colors of the cells in the image you have shared in your post, it works fine from my side. The reason that calendar dates do not become colored in is that the Employee leave tracker table is still blank so that it did not fit the condition of the conditional formatting you have set.

When I fill the Employee leave tracker table, the colors shows again.

If you still have concerns, welcome to reply anytime.

Regards,

Alex

Was this answer helpful?

0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-01T19:15:57+00:00

    Trying to figure out how to upload

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-12-29T22:02:29+00:00

    Hi bouyank557,

    Haven't heard form you for a while. We are very willing to assist. Welcome to reply at your convenience and share more with us.

    Regards,

    Alex

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-12-28T18:25:49+00:00

    Hi bouyank557,

    With the information you have already shared, it's hard for us to locate the issue. Is there any chance you could share the file with us? To protect your privacy, please remove the sensitive information from the workbooks and send it via PM: https://answers.microsoft.com/en-us/privatemessage/inbox

    If sharing the workbook is acceptable, we suggest you share the workbook before you add the leave type options and the one after you add them.

    Regards,

    Alex

    Was this answer helpful?

    0 comments