document conditional formatting rules

argeedblu

New Member
Joined
Sep 13, 2003
Messages
29
I've posted this question on UtterAccess.com but would like to expose it to the Excel oriented community.

My immediate issue is dealing with conditional formatting rules and being able to view more than one rule at a time. I have a set of several rules that control the appearance of a cell. It is difficult to debub logical errors in the rules without being able to compare them. On a broader, more general basis, it would be nice to print all the rules that affect certain cells.

Is there any hope or am I chasing my tail?

Glenn
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
i copy into selerate columns and view from there,so i can see how they return false true , and can help decide what order to put the rules in and also using "stop if true"
 

argeedblu

New Member
Joined
Sep 13, 2003
Messages
29
i copy into selerate columns and view from there,so i can see how they return false true , and can help decide what order to put the rules in and also using "stop if true"
Thanks Wayne,

I'm actually looking for something to make the rules available as a teaching tool.

Glenn
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,073

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
I often create my CF rules IN the worksheet itself. This allows for easier editing. Just formulate them to return either TRUE or fALSE

Plus, doing it that way would simplify "texting" the formulas so you can print them
 

argeedblu

New Member
Joined
Sep 13, 2003
Messages
29
I'll never invest the time in VBA to become good with it, but I'm reasonably good with Google searches: "excel print all conditional formatting rules" [without the double-quotes]. I think these might help you.

Daily Dose of Excel, April 2010:
Listing Format Conditions | Daily Dose of Excel
VBA Express, May 2014, modifies the code from Daily Dose:
[SOLVED] Listing Conditional Formatting on Separate Sheet or Workbook
Many thanks for those links. I had planned to work on a VBA solution as soon as I could find some time for coding. If this code isn't exactly what I need, it is still going to give me a great start.

Thanks again,

Glenn
 

argeedblu

New Member
Joined
Sep 13, 2003
Messages
29
I often create my CF rules IN the worksheet itself. This allows for easier editing. Just formulate them to return either TRUE or fALSE

Plus, doing it that way would simplify "texting" the formulas so you can print them
Ford, that's a great tip. Thanks,

Glenn
 

Watch MrExcel Video

Forum statistics

Threads
1,095,804
Messages
5,446,563
Members
405,407
Latest member
apat

This Week's Hot Topics

Top