Colorize Nightmare

Canuckish

New Member
Joined
Jan 9, 2014
Messages
7
I have a presentation filled with shapes that are the "wrong" kind of red (thanks Marketing) and need to make them the "right" kind of red. A few problems:

1) I don't know what the red value "3747998" means when, with the first shape for re-coloring selected

debug.print ActiveWindow.Selection.ShapeRange.Fill.ForeColor
Worse still, there doesn't seem to be the ''record macro'' button in my PPT app, and

debug.print ActiveWindow.Selection.ShapeRange.Fill.ForeColor.RGB
gives the exact same 7-digit number


2)Once I get the value of the selected shape back, how do I do a loop through EACH shape in the deck with a loop, as in

"If the color value = 3747998 then make it RGB(181, 18, 27)"

Thanks for any help; I am using Excel 2010 on Windows 7.
 
Unfortunately not. The content is copyrighted and this thread does not allow me to post attachments. Basically, it's a bunch of charts, with elements (e.g. bars) that are RGB = 3747998 and need to be RGB(181,18,27). This goes for any sort of shape, which may not have elements within them, like line borders, as well. (Also, text, tables, etc.). I'd like to extend this use case to any shape, with any number of elements within them...
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top