lbrockmeier
New Member
- Joined
- Dec 18, 2017
- Messages
- 7
Hi there,
I want to leverage different filter buttons, but need font color to change when I do that. Columns I and J have the reatilers and metrics in each row, but they are not visible as the font color is the same as the background color. but when I click on the "Discount Rate" filter button, as an example, the name of the retailer (row 15) dissappears as only rows that contain "Discount Rate" (e.g. 17-19) show up.
I need the macro to do 3 things with font:
1) Make text that is currently background color be visible based on filter
2) when filters are cleared, return the font colors to its original position (so a macro that returns font color to the background color). I was toying around with RBG and have those values and created a macro that way, but figured there had to be an easier way.
Let me know!
Thanks in advance.
I want to leverage different filter buttons, but need font color to change when I do that. Columns I and J have the reatilers and metrics in each row, but they are not visible as the font color is the same as the background color. but when I click on the "Discount Rate" filter button, as an example, the name of the retailer (row 15) dissappears as only rows that contain "Discount Rate" (e.g. 17-19) show up.
I need the macro to do 3 things with font:
1) Make text that is currently background color be visible based on filter
2) when filters are cleared, return the font colors to its original position (so a macro that returns font color to the background color). I was toying around with RBG and have those values and created a macro that way, but figured there had to be an easier way.
Let me know!
Thanks in advance.
