| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell color
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell color
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Linear Mode
