VBA to change colors
Posted on 2012-03-14
Hi Guys, what would be the code for
If Range(S6:S450) >=38.75 then VB red, else VB white
If (S6:S450) >=38.75 then Range(B6:B450)VB red, else VB white
I need the code to activate these 2 columns depending on Column S values
I did this with conditional format but it slows down my sheet operation.