I've added code to filter and print each condition apart from empty cells because I don't understand what you mean.
The code currentl previews but you can delete that line and use the PrintOut line
This simple coding makes sense. But the main conditions were missing.
I want to highlight entire rows according to 4 conditions based on the cell values on column 'G'.
a. 45 and above - no filtered color
b. between 30 and 45 - yellow color
c. less than or equal to 30 - Red color
4. any blank cell - no filtered color
These highlighted rows will be copied and pasted to the multiple sheets for later review with a single click. If I require it, I will print it. Therefore, I can see immediately which Staff IDs are yet to renew. Yellow ones will be pasted in ''Required Action'' and Red rows will be pasted in ''Fast Action'' maintaining the resizing formatting.
I hope, I could make the idea clear.