You are welcome Alan..

To copy the conditional formula to other rows... just remove the dollar sign from the formula and start dragging.. you can also copy - paste special- formats. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>