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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to dynamically add up varying # of cells base on a value 12
Excel Macro to automatically go to the right of the last colored cell 0
Change Color of cell 3
Conditional Formating based on Date 5
Counting Cell Color? 2
Change the color of a cell 7
Meeting 12 formatted conditions 9
Column Heading on each row in pivot table 1

Back
Top