I want to copy the conditional format that I created to additional lines. I
have followed the instructions to select the cells that have the format. Then
click on format painter, select the cells I want to add that condition to but
it is not copying the format. I'm tracking data on a monthly basis and want
to highest number to highlight on each row. My formula is: if ($e3$:$aq3$)=a3
then high light it red...