Macro Needed with RGB
Hi all,
I have the following workbooks that I need your help with a macro.
The workbook names are as follows:
025-FY 19-Monthly Report
050-FY 19-Monthly Report
056-FY 19-Monthly Report
100-FY 19-Monthly Report
130-FY 19-Monthly Report
135 FY 19-Monthly Report
Everyone of this workbooks has the following sheets with the following names:
FY 19 Budget
FY 19 Actual
FY 18 Actual
FY 17 Actual
FY 15 Actual
In every sheet, there are between three and five rows (maybe less/more) with a RGB value of (0, 0, 0), which is black color.
I'm hoping that with your help I can change the RGB value of (0, 0, 0) to a RBG value of (192, 192, 192).
I don't know what will be the best method to accomplish this. Not sure if we can use Find and Replace option or if an IF option can do it.
I'm attaching a copy of one of the files so you can see the colors in the rows.
Hopefully, with the macro I should be able to change the RGB value on all the workbooks.
Thank you in advance for your support.
Regards,
rsrasc
|