RE: Change Cell Background color when Cell changes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Steve

Here is a simple solution that you can use as a starting point.
Right click the *** tab and select view code.
Past this code onto the *** module:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 37
Target.Interior.Pattern = xlSolid
End Sub

This will change the background of any cell which is changed to blue. You
can play around with the ColorIndex to select another colour.

Hope this helps
Rowan

"Steve Roberts" wrote:

> I have a Department that wants to have a button added to a work*** that
> would 'watch' for any cell changes. If a cell changed, make the background
> of that cell a different color. Is there a way to do this?
>
> Thanks
>
> Steve
>
>
>
.

Quantcast