asked on
VBA to change colors
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.
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.
Microsoft ExcelSpreadsheetsVB Script
Last Comment
rsen1
It's unlikely that VBA will be faster than Conditional Formatting. Indeed, it would probably be slower to use VBA with a Change or Calculate event sub than to just use CF.
ASKER
Thank you for your response, but would you please help me with code all the same?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you very much