Change cell color

  • Thread starter Thread starter an
  • Start date Start date
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
 
Let's say the SUM() is in A1
Conditional format: Formula is =A1<MONTH(TODAY())*100; format to some colour
best wishes
 
Back
Top