(Excel 2016) I have several large spreadsheets with existing conditional formatting. On any particular sheet I have several tables each with it's own set of conditional formatting. The tables change in size so the ranges vary. And there are lots of them (100's). The same rules apply to each set, that is, the conditional formatting I want to edit is consistent, with the same "set" of 4 formats that apply to each range/table (e.g. Red/Yellow/Green/Blue).
I'm trying to figure out how to edit a color value in the existing formatting. For example change a text color that is currently green, to light green. Right now I have to manually edit hundreds of formula entries.
I've seen lots of examples on applying conditional formatting via VBA, but I don't see how I can step through these tables and edit the existing formats, without changing their order or precedence.
No comments:
Post a Comment