New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

List Conditional Formats

Free Excel Macros
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

List Conditional Formats

Postby Sisyphus » Sat May 10, 2014 12:24 am

Setting the Applies To property of conditional formats can be a task in which Excel's CF Manager dialog box quickly reaches its limits of usefulness. The answer is to list all existing formats and then refer to this list while making modifications in the CF Manager.

Simply drag the CFman code module from the attached workbook to your own project and run the procedure ListCFs after setting the SourceSheet constant to the name of the tab you wish to examine. The worksheet in the attached workbook is only intended for easy testing. It isn't required in your project.

The worksheets the code creates can be deleted when no longer needed for reference.

The code in CFman includes the procedure LastRow which is required in most VB projects. If this is the case in your own project, replace all existing code requiring the last row in any column of any sheet with calls to this function with the appropriate arguments.
You do not have the required permissions to view the files attached to this post.
Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010

Return to Excel Macros

Who is online

Users browsing this forum: No registered users and 1 guest