Hey guys,

I have this macro that copies the whole row on another sheet if a cell contains Yes. I have added this macro to the sheet.

Please Login or Register  to view this content.
I want to add it another functionality to it. If the font color of a cell in column with Range A15:A1020 is green, and the Range in C15:F1020 has a value bigger than 0, to color the interior of the cell in red.
Also if the font color of Range A15:A1020 is red and the range of U15:V1020 has a value bigger than 1, to color again the interior of the cell in red.

I tried to add the code below to the above macro, but it doesn't seem to work.

Please Login or Register  to view this content.
Thank you in advance!