Forum Discussion
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,...
Strange. Here is my sample workbook. Does it work for you?
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...
I created the button manually, from the Developer tab of the ribbon.
You don't really need it in your workbook - the macro needs to be run only once.
The other code, that should go into the worksheet module (right click sheet tab > select 'View Code') will update the colors automatically when you change values in column H.
One caveat: it won't work if the HP values in column H are formulas.
- I did hit "run" from the code viewer though after saving/reopening.