Forum Discussion
NateW321
Feb 09, 2022Copper Contributor
Conditional formatting between rows with different values (words vs numbers)
I'm searching for used cars and have the make/model in Column B. I have the horsepower rating in Column H. Column H is conditionally formatted using gradient color scales to show most power in green,...
NateW321
Feb 09, 2022Copper Contributor
Yes, it does. I prefer the code that automatically updates column b though.
This has, however, exposed my lack of knowledge on macros. When I put the code in my spreadsheet you used in your example, I didn't have a button show up on the sheet...
This has, however, exposed my lack of knowledge on macros. When I put the code in my spreadsheet you used in your example, I didn't have a button show up on the sheet...
NateW321
Feb 09, 2022Copper Contributor
I did hit "run" from the code viewer though after saving/reopening.