Hello everyone
Please be careful with me as I am new to conditional formatting using VBA
I am looking to conditional format a range (basically a grid with a calendar year entered into it) from a list of dates as below but I also want to sub categorise the dates in different colours.
Is this possible? and if so how the hell do I do it?!
Category 1
From To
01-Apr-15 15-Apr-15
05-Jun-15 20-Jun-15
26-Aug-15 08-Sep-15
18-Dec-15 06-Jan-16
Category 2
From To
01-May-15 15-May-15
05-Jul-15 20-Jul-15
26-Sep-15 08-Oct-15
18-Jan-16 06-Feb-16
Category 3
From To
01-Jun-15 04-Jun-15
05-Aug-15 20-Aug-15
26-Oct-15 08-Nov-15
18-Feb-16 06-Mar-16
Please be careful with me as I am new to conditional formatting using VBA
I am looking to conditional format a range (basically a grid with a calendar year entered into it) from a list of dates as below but I also want to sub categorise the dates in different colours.
Is this possible? and if so how the hell do I do it?!
Category 1
From To
01-Apr-15 15-Apr-15
05-Jun-15 20-Jun-15
26-Aug-15 08-Sep-15
18-Dec-15 06-Jan-16
Category 2
From To
01-May-15 15-May-15
05-Jul-15 20-Jul-15
26-Sep-15 08-Oct-15
18-Jan-16 06-Feb-16
Category 3
From To
01-Jun-15 04-Jun-15
05-Aug-15 20-Aug-15
26-Oct-15 08-Nov-15
18-Feb-16 06-Mar-16