I am following a few clues gleaned from this forum, and am trying to write my own macro for extending the conditional format function to more than 3 options.
Having recorded the macro for 3 options - and I now go to edit the macro, and can plainly see the recurring nature of the code. I would presumably simply copy using cut and paste the repeated code which is appearing in the editor, and change the conditions etc etc - and "voila!"- theres the macro??
The problem is that I am formatting cells by colour related to todays date - and want a fine grained formatting (ie subdivided by the week - but extending say 3 months into the future). The macro code refers to "Colorindex=44" etc - which refers to the color palette.
How can I establish what "Colorindex" all the colors in the palette are (without a trial and error investigation)?
I am of course assuming I have not already barked up the wrong tree with my whole approach in the first place.
Any help most appreciated
Having recorded the macro for 3 options - and I now go to edit the macro, and can plainly see the recurring nature of the code. I would presumably simply copy using cut and paste the repeated code which is appearing in the editor, and change the conditions etc etc - and "voila!"- theres the macro??
The problem is that I am formatting cells by colour related to todays date - and want a fine grained formatting (ie subdivided by the week - but extending say 3 months into the future). The macro code refers to "Colorindex=44" etc - which refers to the color palette.
How can I establish what "Colorindex" all the colors in the palette are (without a trial and error investigation)?
I am of course assuming I have not already barked up the wrong tree with my whole approach in the first place.
Any help most appreciated