tag:blogger.com,1999:blog-1869924468172210809.post5959293959574422588..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tip: Merry Christmas with a quick macro to swap one colour for anotherGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1869924468172210809.post-85799790421905873912015-12-22T11:24:55.566+00:002015-12-22T11:24:55.566+00:00That's excellent! I'll have to have a play...That's excellent! I'll have to have a play with that! No matter how much you think you know Excel, there's always so much more to learn! Thanks, and Merry Christmas.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-7476625827220137312015-12-22T11:11:59.333+00:002015-12-22T11:11:59.333+00:00no, you can enter partial formats,
you can even sa...no, you can enter partial formats,<br />you can even sample an existing one from a cell then edit out the attributes you don't care about<br />really quite a powerful (underused and little-known) technique<br /><br />jAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-90109863172288026862015-12-22T10:56:01.511+00:002015-12-22T10:56:01.511+00:00Jim
I use Find and Replace all of the time and ne...Jim<br /><br />I use Find and Replace all of the time and never realised that you could do it with formats! You learn something new every day!<br /><br />Presumably it has to be the whole format rather than just the colour, which might not work in every scenario?Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-59625178300625059852015-12-22T10:51:48.239+00:002015-12-22T10:51:48.239+00:00Thanks J, you beat me to it!Thanks J, you beat me to it!Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-50601711420964016592015-12-22T10:21:43.554+00:002015-12-22T10:21:43.554+00:00click the Fill Colour dropdown, then More Colours,...click the Fill Colour dropdown, then More Colours, then select the colour you want, then click Custom. RGB values are shown for that colour<br />no, you don't want to have to do this on a regular basis<br /><br />jAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-1822262002200200202015-12-22T10:11:04.840+00:002015-12-22T10:11:04.840+00:00use Styles?
or if you've not been so proactive...use Styles?<br />or if you've not been so proactive (and who is?), use Find and Replace where, when the Options are expanded, there is the ability to replace one format with another (leave the Find what: and Replace with: boxes blank and the contents will be unaffected)<br /><br />jimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-57834679257734012022015-12-22T10:09:45.631+00:002015-12-22T10:09:45.631+00:00Now, where do I get the RGB values from if I requi...Now, where do I get the RGB values from if I require a pale green, or pale yellow or full on red?Anonymousnoreply@blogger.com