Tom.Jones
Well-known Member
- Joined
- Sep 20, 2011
- Messages
- 509
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
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.
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.