Date and amount

[Closed]
Report
Posts
1
Registration date
Wednesday December 16, 2015
Status
Member
Last seen
December 16, 2015
-
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
-
Hello,
I need to write a formula to give me alarm by turning the cell to red color and the formula is about the following:

If the amount in Cell (AE300) is bigger than zero and the date is 30 days before the date in cell (G300), then change the cell (AE300) color into red.


Thanks in advance.

1 reply

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi MidoBadawy,

You could setup a conditional format for AE300.

The formula will look something like:
=AND(Condtion 1, Condition 2)

Condition 1: AE300>0
Condition 2: (G300-30)<TODAY()

Best regards,
Trowa