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


" wrote in message
ups.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).

" wrote in message
ups.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

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?



" wrote in message
ups.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

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

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...