I am trying to create a timeline format in excel using UiPath.
Let’s say I have 10 rows of items (names in A2:A12), each item is assigned a date (dates in B2:B12). For the next 36 columns, it is the next 36 months (3 years). For example, C1 says Jul-20, D1 says Aug-20, E1 says Sep-20, etc.
For example, if a date in B2 says 8/1/2020, I want it to highlight cell D2 (the Aug-20 column) in yellow. If the date in B3 says 9/1/2020, I want it to highlight E3 (the Sep-20 column) also in yellow.
The dates in the B column need to be in mm/dd/yyyy format, but the format for columns C onward do not need to be in Jul-20 format, it can be mm/yyyy, July 2020, etc.
The timeline is the next 36 months, so if we’re in July of 2020, the last column would say June 2023.
Thank you so much in advance!!!