Cell value change/color change

  • Thread starter Thread starter Koen Bertoen
  • Start date Start date
K

Koen Bertoen

I have spreadsheets autofilled by a financial information vendor program.

Can anyone point me in the right direction how to change the color of a cell
if the content changes, eighter
green for positive chsnge and red for negative change ?

Preferably in two modes: 1) the color remains after the change, or,
2) the color dissapears
after a couple of seconds.

Gratefull for any help.


Koen.
 
Try looking under Format, Conditional format... and choose
your format base on the boxes you fill in. Before you do
this highlite the cell(s) you want changed.
 
Koen Bertoen said:
I have spreadsheets autofilled by a financial information vendor program.

Can anyone point me in the right direction how to change the color of a cell
if the content changes, eighter
green for positive chsnge and red for negative change ?

Preferably in two modes: 1) the color remains after the change, or,
2) the color dissapears
after a couple of seconds.

Gratefull for any help.

Koen.
Click to expand...

You need a macro for this.
 
You must log in or register to reply here.

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

changing cell background colors with formulas 5
change text color when the value become lower than a certain value 1
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
auto change font color in formula/cell 1
Macro To Change Cell Color When Value Changes 4
Changing Cell Color Based on Value 2
Changing cell colors from a function command 3
Counting Cells by Format 2

Back
Top