How To Copy Conditional Format To Cells

By Carol Bratt / 07/06/2023 / How-To, Mac OS X, Microsoft Excel, Microsoft Windows

This is so easy that you will wonder why you have not used it all along. I am certain that you will use it all the time now that you have learned how easy it is!

Select the cell that has the conditional formatting that you want to copy.
On your Home tab (or the Standard toolbar in Excel for Mac 2011), click Format.
Then select the cells where you want to copy the conditional formatting.

About The Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.