Populate a cell with text and formatting based on a whether a date field falls within a date range

[MLC1980]

Hi,

I'm trying to automatically populate a specific cell with some text and some formatting based on whether a date falls with a date range. To try and explain this further, these are the fields I'm looking at:

Cell G1 = Start Date
Cell G2 = End Date
Cell B13 currently has an 'IF' statement to apply the same date as Cell G1 (This is week 1)
Cells B14:B64 are weeks 2 to 52 and populate by applying 7 days to the previous date (e.g. cell B14 is B13 plus 7 days, cell B15 is B14 plus 7 days)
Cell C13:C64 are the cells that I want to automatically populate.

The rule I want is that if Cells B13:B64 fall within the start and end date range in cells G1 and G2 then populate Cell C13:C64 with "ML/AL", I also want the cells formatted with a fill colour of purple (R112,G48,B160) and a font colour of white. This would be the same for the rest of the weeks.

Is this possible with VBA?

 

[Micron]

Should be doable with or without vba. Perhaps simpler to use a formula and a CF rule? Using this formula
=IF(AND(B1>$G$1,B1<$G$2),"ML/AL","") in C1 and C2 and date range in G1 and G2 I get this result with these dates in B1 and B2:

With the menu selections (shown as light green)

The rule is

 

[MLC1980]

@Micron, thanks for your solution. I just altered the formula slightly to account for including the start and end date:

=IF(AND(B13>=$G$1,B13<=$G$2),"ML/AL","")

Many thanks

 

[Micron]

Glad I could help & thanks for the recognition. I don't understand what you mean about the adjustment though since we both used $G$1 and $G$2 for those dates. What you posted looks the same to me except you started with row 13 for B column values while I started with B1.