I want most of the cells in a row to be magenta if they are modified, & thus my code is below. However, I want to exclude cells 16, 22 & 23 from becoming magenta. I tried using vbwhite (per code below) but the result is that the cell border is also removed.
I figure its a simple answer but I cannot find one.
If Target.Column >= 1 Then Target.Interior.Color = vbMagenta
If Target.Column = 16 Or Target.Column = 22 Or Target.Column = 23 Then Target.Interior.Color = vbWhite