8 replies
by zimonar
by zimonar
by justin james
No, the previous poster said that you should use VBA, which means "write a macro". You are not going to accomplish this goal without a macro. I'm not going to write actual code, but I will tell you how the code should function:
1. Loop through the "UsedRange" range on the sheet you are working with.
2. Test for the existence of conditional formatting code within that cell.
3. If the cell contains conditional formatting, add that cell reference to a string that represents a range.
4. When finished looping, select a range, using the string you constructed as the range specification.
by zimonar
by zimonar
Well, you mean by VBA is Visual Basic? And I thought that VBA is a function that I was looking for in the Insert Function dialog box. I only know how to record and make run a macro but I still don?t have any idea about the VBA.
Any how, thank you very much.
by zimonar
by zimonar
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending