SOLVED

Highlight n number of data type DATE cells using conditional formatting

New Contributor

The start date and end date are manually entered and the number of days and number of months between are calculated. The number of months, calculated as being 3 (or whatever the case may be) should indicate the number of cells that should be highlighted and this should start at the month of the start date (October in this case) and end on month of the end date (December in this case) and include all cells in between. I don't know how to highlight multiple cells. If it goes from November 2022 to February 2023 then that would be 4 months highlighted, and so on. Is this even possible? Any ideas?

 

Screenshot of what I'm working with:

https://imgur.com/ldVX1Lw 

2 Replies
best response confirmed by kharigray (New Contributor)
Solution

@kharigray 

Select the range of cells that you want to format, beginning in H3, for example H3:S22.

H3 should be the active cell in the solution.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=AND(H$2>$D3-DAY($D3),H$2<=$E3)

 

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

Thanks, this wasn't exactly what I needed but it provided some insight!