Question: how to copy conditional formatting in excel to another sheet?
Answer: Select the range whose conditional formatting you will copy, and click Home > Format Painter .
Shift to the destination range, and drag the paintbrush across this range.