Date and amount

Closed
MidoBadawy
Posts
1
Registration date
Wednesday December 16, 2015
Status
Member
Last seen
December 16, 2015
- Dec 16, 2015 at 03:59 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Dec 17, 2015 at 11:08 AM
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

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Dec 17, 2015 at 11:08 AM
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
0