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

Attached Files

100-FY 19-Monthly Report.xlsx (58.6 KB, 12 views)