VBA Code on How to change values in column range(true/false) based on vbred selection.change in other column

[silvanus3805]

Please help me with another Thread? Im Trying to get VBA To Change Values ( True / False ) In [Column2 VBA] everytime Selection.change event happens in the [Column1] range , lets assume the color in column1 is = vbred , I need vba formula to change the values (True/False) in the 2nd column based on the color in column1 , NB: VBA code only not the function method

 

[My Aswer Is This]

If you're wanting us to write a script that will run when you change the color in any cell in column A I'm not sure that's possible.
And selection change occurs anytime you move from one cell to another not just when you change a cells color.

 

[silvanus3805]

Yes,But it doesn't necessarily mean that it should happen after selection change, Isn't there a simple VBA whereby if any cell in column1 = VBA Red then the corresponding row in the next column should be = True ??