how we can copy the "conditional format" to other column?
e..g. A1:A10 has defined the format by using "Conditional Format". How can we copy the "Conditional Format" of A1:A10 to B1:Z:10 ?
Thanks.
MS Excel - Conditional format
2008-07-05 4:34 am
回答 (1)
2008-07-06 7:08 am
✔ 最佳答案
1. Highlight A1:A10, then COPY2. Highlight B1:Z1, then use PASTE SPECIAL -- FORMATS
收錄日期: 2021-04-19 17:25:57
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080704000051KK02411