Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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