I need help adding a coloration to my existing column hiding Macro. I see a lot of statements that Conditional Formatting is better, but I need this to be available to dozens of people on brand new spreadsheets they export into Excel. Currently I have the Macro added to my Custom Toolbar and will be doing the same for everyone else.
So if there's a way to develop a Conditional Format option that I can connect to my existing VBA to allow for the single button press, that will be great. But the people using this will be using it half a dozen times a day and I don't want them to have to add the Conditional Formatting for each time.
The goal: Some of the rows will have "Service Reference" in Column J. These lines are reference lines for all the other lines and so I want to be able to separate them out from the rest with a bright yellow highlight across the row. I've found a few online but they all seem extremely specific and I haven't been able to re-formulate for my purposes.
I greatly appreciate any help that can be provided.
So if there's a way to develop a Conditional Format option that I can connect to my existing VBA to allow for the single button press, that will be great. But the people using this will be using it half a dozen times a day and I don't want them to have to add the Conditional Formatting for each time.
The goal: Some of the rows will have "Service Reference" in Column J. These lines are reference lines for all the other lines and so I want to be able to separate them out from the rest with a bright yellow highlight across the row. I've found a few online but they all seem extremely specific and I haven't been able to re-formulate for my purposes.
I greatly appreciate any help that can be provided.