Excel Quickie 28: [ Ссылка ]

Easily browse a worksheet to quickly see every cell that has conditional formatting applied to it.

How to quickly select or highlight all cells in a worksheet that have conditional formatting applied to them - this works even when the conditional formatting is not currently visible.

This is different from going to the Rules Manager for Conditional Formatting because that shows you only a list of rules inside a small window and doesn't allow you to easily browse a worksheet to quickly see every cell that has conditional formatting applied to it.

This is a nice little Excel Quickie that should help speed up your work process, especially when you are dealing with worksheets that someone else sends you, but doesn't thoroughly explain.

Enjoy!

TeachExcel.com

#excel #msexcel #tutorial

свернуть