Change cell color

A

an

Hi!

I would like to create a formula for the Conditional Formatting change the
color of a cell with SUM, if there isn't the value which today should exist.

One practical example:

We are in JUL. If since JAN had been a monthly deposit of 100, (TODAY) there
are 700.
If the cell with SUM calculate less than 700, advise us.

Thanks in advance.
an
 
B

Bernard Liengme

Let's say the SUM() is in A1
Conditional format: Formula is =A1<MONTH(TODAY())*100; format to some colour
best wishes
 
Top