Previous Topic Next Topic

Date and amount

Closed
MidoBadawy Posts 1 Registration date Wednesday 16 December 2015 Status Member Last seen 16 December 2015 - 16 Dec 2015 à 03:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Dec 2015 à 11:08
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
17 Dec 2015 à 11:08
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