Hi,

I am trying to create a macro that will, when a command button is clicked,
copy a row and format it the same from one sheet to another if the color of
the font in one of the cells of that row, let's say column E, is red or
yellow.

Also, if it doesn't copy one row, I would like it to paste the next row
fitting the above font color conditions on the line right below in the new
sheet.