Converting Conditional Formating into VBA Code

[CDNWolf]

Hi guys,


I'm looking to change from Conditional Formatting to VBA Code... I am fairly new to VBA so any assistance would be appreciated.


The spreadsheet I am using has a START and END date. For example L10 = 01/01/2015 and M10 = 01/04/2015. Each row has a different date, etc

The RANGE I am using to format (Backgroung Colour / Fill) is $N$10 - $MK$5011. Each of these cells is filled with a fixed date ranging from 01/01/2014 - 31/12/2020. The dates are hidden using a text colour of white so they are not visible...


The Conditional Formatting I am using states if N10 is between L10 and M10 then fill with RED.
Example L10 = 01/01/2015, M10 = 01/04/2015, N10 = 01/01/2015, therefore N10 should be Coloured RED as it is within the range of 01/01/2015 and 01/04/2015...


In addition I want to also check the date against G10 and H10 and fill it GREEN and finally checking again I10 and K10 and filling with YELLOW.


The Conditional Formatting is working well as a visual aid but I can not count the filled cells and create charts / Graphs, etc...


Thanks in advance for your advice.

 

[VoG]

This may help you Conditional Formatting Colors

 

[CDNWolf]

Thanks VoG but that link is very confusing and a lot of programming, not sure if I understand it...

 

[CDNWolf]

Can anyone else assist with this ?