Change the backgroud color according to condition

Hi all,

I woulid like to enhance my form by changing the backgroud color of my
text box when the firstname change.
I would like to have something like that:

Name : MARTIN

First name
Alan xxxxxxx 00000000 (blue)
Alan rrrrrrrrrrr 11111111 (blue)
Alan zzzzzz 22222222 (blue)
Peter aaaaaaa 11111111 (red)
Peter xxxxxxx 00000000 (red)
Zita eeeeeee 22222222 (blue)


Is it possible and who has any idea ?

"Tschuß" wrote in message
...
Hi all,

I woulid like to enhance my form by changing the backgroud color of my
text box when the firstname change.

Is it possible and who has any idea ?

Look up Conditional Formatting. That does exactly what you want.

Tom Lake

On 29 avr, 13:49, "Tom Lake" wrote:
"Tschuß" wrote in message

...

Hi all,

I woulid like to enhance my form by changing the backgroud color of my
text box when the firstname change.
Is it possible and who has any idea ?

Look up Conditional Formatting. *That does exactly what you want.

Tom Lake

Do you have an example because I don't know how to make my condition
for my pb ?