rohitnigade
New Member
- Joined
- Oct 7, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- MacOS
Hi,
I have an array which is a dynamic calendar (B4:H9) (Let's call it 'Calendar Array"). I have another array(K4:Q9), which is also dynamic, but it only contains the dates that an employee is on leave (Let's call it 'Leave Array"). The Calendar Array is populated based on the inputs in C1 and E1, the Leave array is populated based on the inputs in L2:M2. I want to highlight these leave dates in the Calendar array. I could do this using duplicate values, but the Leave Array here is only for representation, in reality it would not be here and should only be used for the Conditional Formatting formula. I need help with creating such formula for Conditional Formatting that will highlight the dates in Calendar Array based on the inputs in L2:M2.
Any help will be really appreciated.
I have an array which is a dynamic calendar (B4:H9) (Let's call it 'Calendar Array"). I have another array(K4:Q9), which is also dynamic, but it only contains the dates that an employee is on leave (Let's call it 'Leave Array"). The Calendar Array is populated based on the inputs in C1 and E1, the Leave array is populated based on the inputs in L2:M2. I want to highlight these leave dates in the Calendar array. I could do this using duplicate values, but the Leave Array here is only for representation, in reality it would not be here and should only be used for the Conditional Formatting formula. I need help with creating such formula for Conditional Formatting that will highlight the dates in Calendar Array based on the inputs in L2:M2.
Any help will be really appreciated.