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,...
HansVogelaar
Feb 09, 2022MVP
Strange. Here is my sample workbook. Does it work for you?
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...