Oct 07 2022 06:53 AM
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
Oct 07 2022 09:40 AM
SolutionSelect 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.
Oct 13 2022 09:40 AM
Oct 07 2022 09:40 AM
SolutionSelect 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.