Change cell background color if cell is empty?

[Aland2929]

I want to change the background color of the cell to red if the user has not entered a value in the cell NewPrice. Once the user starts to type a value in NewPrice, I would like the background color to change to white? The 2nd line of my code does not work?

Please Login or Register  to view this content.

Thanks in advance

[Aland2929]

if I can get the 2nd line correct, I think I can use the "Change Event" to change the background color back to white?

[AlphaFrog]

The 2nd line of my code does not work?

Please Login or Register  to view this content.

That's the correct syntax. Does it throw an error? Do you have a named range called NewPrice (check spelling)? Is the cell truly empty?

[Aland2929]

Thanks for your reply. I have a range name NewPrice and spelling is correct. The error message is:
Run-time error '1004':
Application-defined or object defined error

[Aland2929]

I changed the 2nd line of code but still receive the same Run-time error '1004': Application-defined or object defined error

Please Login or Register  to view this content.

Thanks in advance.

[Aland2929]

The sheet I am working on was a protected sheet. I unprotected the sheet & then it worked. Thanks for your assistance.