RAG formuale help

Question

Hi Guys

I'm trying to get the right formulae to do the following;

Cell B5 shows the date 16/09/2024. I would like this to be green until 16/09/2025 - on this date I would like it to turn red.

Can someone help me out with the correct formulae please? I'm struggling to wrap my head around it.

TIA you clever clever souls!

Answer 1

Hi respected Dani3113,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad

Answer 2

Start by making all the cells green manually, then add conditional formatting.

Today's date is 19th Sept 2024. Outlined cells above are a day apart, the rest are a month apart.

Answer 3

Select the cell(s) you want to format.

Set the fill color to red. This will be the default.

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 'greater than' from the second drop down.
In the box next to it, enter the formula

=EDATE(TODAY(), -12)

Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.

Answer 4

Dear respected Dani3113,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description,

For Green Formatting:

=AND(B5>=DATE(2024,9,16), B5<DATE(2025,9,16))

For Red Formatting:

=B5=DATE(2025,9,16)

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad