Akshay Handoo
New Member
Dear Excel experts,
I have created a horizontal 1 year calendar with names of all employees in row B3: B40. When leaves are applied in 'Leave tracker' sheet, it will highlight the same dates marked in 'Leave cal' sheet depending on dates mentioned.
Please help me without any VBA for a conditional formatting formula which can
1. Write text in sheet dynamically from "H3" leave tracker sheet in the middle of the highlighted dates of the 'Leave cal' sheet. Text to appear over the highlighted color once in the center of the highlight color.
I have created a horizontal 1 year calendar with names of all employees in row B3: B40. When leaves are applied in 'Leave tracker' sheet, it will highlight the same dates marked in 'Leave cal' sheet depending on dates mentioned.
Please help me without any VBA for a conditional formatting formula which can
1. Write text in sheet dynamically from "H3" leave tracker sheet in the middle of the highlighted dates of the 'Leave cal' sheet. Text to appear over the highlighted color once in the center of the highlight color.