Changing background color when changing value

Hi there,

I was wondering if it is possible to change the background color if
someone changing the value of a cell, or put in a new text in a cell.
I think it is only possible with a VBA code...

Can anybody help me?

Cheerio

It's also available with Conditional Formatting (Menu, Format,
Conditional Formatting). See Help for details


"blommerse@gmail.com" <blommerse@gmail.com> wrote in message
news:1152181407.047597.67070@m79g2000cwm.googlegroups.com:

> Hi there,
>
> I was wondering if it is possible to change the background color if
> someone changing the value of a cell, or put in a new text in a cell.
> I think it is only possible with a VBA code...
>
> Can anybody help me?
>
> Cheerio

Thanks Jim,

But when the value from the formule is changing it is not possible to
do it like you why.
Actually I need a code or something that said: When changing
value...background turn into red.

Hope you've got something.

Cheers

Not sure what you are saying, better give a complete specific example.
<<because Conditional Formatting would recognize change based on recalcs
(other formulas)>>.

"blommerse@gmail.com" <blommerse@gmail.com> wrote in message
news:1152182257.960731.229750@75g2000cwc.googlegroups.com:

> Thanks Jim,
>
> But when the value from the formule is changing it is not possible to
> do it like you why.
> Actually I need a code or something that said: When changing
> value...background turn into red.
>
> Hope you've got something.
>
> Cheers

I will give you an example

The value of the formule is 999, when the value of the formule change
to 1000, the back ground color of the cell have to change into red.
Do you understand now??
Greets

blommerse@gmail.com wrote:
> Thanks Jim,
>
> But when the value from the formule is changing it is not possible to
> do it like you why.
> Actually I need a code or something that said: When changing
> value...background turn into red.
>
> Hope you've got something.
>
> Cheers

Hi blommerse

Try this in the worksheet's code:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.Color = vbRed
On Error Resume Next
Target.Dependents.Interior.Color = vbRed
End Sub

Remove the On Error... and ...Dependents... lines if they are not
needed.

Regards

Steve

Sorry blommerse, but let's say
Your formula is in cell A3 =A1+A2
A1 = 500
A2 = 499

Select A3 - Menu, Format, Conditional Formatting,
Select CellValueIs in first box select "greater than"
In Next Box enter 999 - Click Format button - Pattern
Select RED.

OK, OK...

Change a2 to 500
What happens?



"blommerse@gmail.com" <blommerse@gmail.com> wrote in message
news:1152185526.792151.80380@m79g2000cwm.googlegroups.com:

> I will give you an example
>
> The value of the formule is 999, when the value of the formule change
> to 1000, the back ground color of the cell have to change into red.
> Do you understand now??
> Greets

It is working when I open a new book, but not in my sheet.
There nothing strange on my sheet, also not protected.
Don't know what's wrong...

It is working when I open a new book, but not in my sheet.
There nothing strange on my sheet, also not protected.
Don't know what's wrong...

Maybe did't give you specific enough info.. I hoped it was as simple as
you typed.

But my workbook has over 700 rows. in column E between 1-700.000. all
the rows can change. What I want to see is that in column E, when a
value is changing, the cell turned red, so I can see which one has
changed.
Unfortunatelly it can't be done in your way.

Hope you've got something else...