» Copying just the Conditional Formatting
CATEGORY - Excel Format
VERSION - Microsoft Excel 2003
If you have the conditional formatting in some cell and you wish to copy just the conditional formatting (ignoring other formats / formulas / contents etc), you can follow below steps.
1) Select the cell which has the conditional formatting.
2) Press the ctrl key and select the other range where you with to apply the existing conditional fomatting (while the ctrl key is pressed)
3) Press Alt + O + D
4) Press Enter
5) Done.
You'll notice that just the conditional formatting has been copied from that cell to other cells in the new range. :)
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- How to Read A Financial Report
- Definitive Guide to Excel VBA
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
