Highlighting cells.

[Tom.Jones]

Hi,

In Sheet 1 is a calendar. Each cell is once formatted to show only numbers from 1 to 31 (obviously, depending on the last day's month may be 28, 29, 30 or 31).
In Sheet 2 in column A starting with A2 some data are passed, and in column B are the names of those data.
I would like to be able to put certain colors in certain cells in Sheet 2 (say in Column C) and the data in Column A be highlighted in the same color in the Sheet 1 calendar.

Let's say that in A2 sheet 2, it is 01.02.2019, in B2 is the name of that day and in C2 I put the red color. I would like the calendar date of 01.02.2019 (dd.mm.yyyy) to be colored in red.
Because there is a lot of data I would like to highlight I would like to not use Condition Formatting, but a VBA code.

Is that possible?
Thank you.

 

[mumps]

How are the cells containing the dates formatted? I think that it would be easier to help and test possible solutions if I could work with your actual file which includes any macros you are currently using. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.

 

[Tom.Jones]

mumps, thanks for the effort to help me, but, I can not send files from here. The company's policy.
calendar dates are formatted to show only the day (from 1 to 31, or 28, 29 or 30)

I will try to restore the file, at home, and send it from there.