Excel formatting

Hello Alka,

Thank you for your question.

The best way to achieve this is by using Conditional Formatting. You can create a rule as follows:

Assuming the original date is in cell A1 and the reference date is in cell B1:

Select cell B1, then go to Conditional Formatting > New Rule > Use a formula to determine which cells to format

In the field below the heading 'Format values where this formula is true', type the following formula (adjusted to your data):

=$B1>=$A1+30 *(or +29 if you want to include the 30th day after)

Make sure there are no $ signs before the row numbers, otherwise you can't apply the rule to other rows.

Click the Format button to set your desired formatting, then click OK.

Afterwards, you can copy the rule to other cells by using the Format Painter or filling down using the 'formatting only' option.

I hope this helps.

Kind regards
Marius Barnard
STL