Whilst searching around trying to find a method for displaying the formula in a cell so that I can convert the formula into a text string.
Sidebar1: I'm surprised how often this comes up. I often want to sort entries by the file they are linked to.
I ran across this http://www.mvps.org/dmcritchie/excel...tm#CondFormula
Which I think might prove useful for documenting the conditional formats applied in a spreadsheet.
Sidebar2: I haven't found a better solution to the original problem than the one proposed by Steve in <post#=300,825>post 300,825</post#>