Forum Discussion
Solved
Conditional formatting to identify a date in x month's time (3 months and 6 months)
Hello clever people. I have a workbook that has dates along the top as row headers. the dates are 01/MM/YY but formatted to show mmm-yy. I need to be able to quickly show month's that are in...
Select the dates in the header row.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula
=EOMONTH(TODAY(), 2)+1
Click the Format... button.
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
Repeat these steps, but with the formula
=EOMONTH(TODAY(), 5)+1
Select the same fill color or a different one, according to your preference.
Hi,
That works for the formula, thank you.
Unfortunately the conditional formatting is making dates in the past go orange too. For example, if the date is 14-Mar-2023, it's also highlighting that.
That works for the formula, thank you.
Unfortunately the conditional formatting is making dates in the past go orange too. For example, if the date is 14-Mar-2023, it's also highlighting that.