VB Micro, fill cells with color based on percentage

I am working on an excel sheet, this sheet contains a list of drawings for a building, which contains 24 floors, each floor has a set of drawings that differs from other floors, which contains of course many systems, well I will concentrate here on the Electrical part.

drawings lists reside in column #3 (C- Column), 1st approval code reside in column #12 (column L), second approval code resides in Column #18 (Column R) and third approval code reside in column #24 (column X). on the next sheet, Completion_Graph, there is a table, shows the floors along with the number of associated drawings which belong to it. also, there is a schematic showing the distribution of the floors and how they will look like at the end.

The Needed: I need a micro, doing a collection of all updated sheets and reflecting it in the master sheet named schedule of submittals with approval codes and dates.

2- fill the cells associated with the floor with green as progress goes, I mean if for example basement 04 has 84 drawings, 32 were approved, completion percentage is 38% and because the floor consists of 12 cells as you will see in the attachment, so 38% x 12 = 4.57 cells, and those 4.57 cells need to be filled with green.
3- convert all sheets into one pdf and send an email containing all sheets in pdf and xlxs file only not xlsm one, dated by today's date

Appreciate all hints, guidelines you may offer, I am definitely positive you will be a great help for me

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Hi,

The first thing we need is sight of the workbook, or at least a representative example.

The colouring can probably be achieved by using conditional formats.
Creating one pdf and xlsx file for all sheets will probably need a macro to copy all sheets into a single temporary sheet.

You have been asked to upload the workbook to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Many members are reluctant to follow external links.