rsen1
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much