Ok, Bernard Liengme.

PERFECT!!!

Thank you very much
an


"Bernard Liengme" wrote:

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