View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
an an is offline
external usenet poster
 
Posts: 37
Default Change cell color

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