Let's say the SUM() is in A1
Conditional format: Formula is =A1<MONTH(TODAY())*100; format to some colour
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"an" wrote in message
...
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