Copy/print Excel formulas with color-coding from edit mode

[dcompto]

Excel 2007, Win 7:

Anyone know a way to copy or print Excel formulas with the color-coding that is shown in edit mode? I know several ways to convert formulas to text, none of which include the color-coding.

TIA.

 

[Lilliabeth]

Print screen key?

--Lilliabeth

 

[dcompto]

Eeeek! That would require doing Print Screen for each individual formula of which there are hundreds...

FOR EACH FORMULA:
1. select the cell
2. F2 to edit (or double-click)
3. Print Screen

I would be left with hundreds of screen shots that would then have to be cropped and formatted into some semblence of a list for printing.

If only Ctrl+` (grave accent) would display the formulas WITH THE COLOR-CODING, although I'm so thankful that it displays the formulas--PERIOD!!!

Anyway, thanks for your response.

 

[SkipVought]

The reason for the color coding is to relate the elements of the formula to ranges on the sheet.

If you COULD do more than one formula, the effect would be entirely lost!!!

I fail to see the point!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Hi Skip,

one part of the colour coding would be useful in printing formulas, and that part is the balancing of the parentheses ... in complex formulas it would be good to see which ")" matches which "(". Maybe that's what the OP meant?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

When I document my sheet formulas, as with ANY documentation,

1. it takes some time

2. it takes some consistency
[tt]
=IF(qORDS[[#This Row],[NET]]<0,qORDS[[#This Row],[QTY]],IF(qORDS[[#This Row],[NET]]<qORDS[[#This Row],[QTY]],qORDS[[#This Row],[QTY]]-qORDS[[#This Row],[NET]],0))

=IF
(qORDS[[#This Row],[NET]]<0

,qORDS[[#This Row],[QTY]]

,IF
(qORDS[[#This Row],[NET]]<qORDS[[#This Row],[QTY]]

,qORDS[[#This Row],[QTY]]-qORDS[[#This Row],[NET]]

,0
)
)
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

Hi Skip,

yes, I agree, and when typing formulas I often include embedded carriage-returns ( Ctrl-Enter ) in the middle of the formula to have them look like that. Excel doesn't mind them, ( apart from splitting the IF from the "(" as in your example, I'm afraid ), as can be seen in this working formula with embedded returns:

=IF(
Sheet2!A1>Sheet2!B1,
      IF(Sheet2!H1=Sheet2!J1+Sheet2!K1+Sheet2!L1,
         "Case found",
                "Ignore"),
  "")

The printing trick would be useful for reading someone elses formulas though, having the matching brackets coloured accordingly.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

D'oh, I meant Alt-Enter!!!!!

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

ah yes, invent the extent of the embedded intent. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[GlennUK]

ha ha, I knew that you'd create a wordplay there

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[dcompto]

Regarding Skip's comment:

If you COULD do more than one formula, the effect would be entirely lost!!!

I'm not wanting every formula's color-coding to be shown when in edit mode--THAT WOULD cause the "effect [to] be entirely lost!" I want to be able to print only the formulas in the Summary section of the worksheet as if I had pressed Ctrl+` (grave) except I need the formulas to be shown with the color-coding.


Regarding GlennUK's comment:

The printing trick would be useful for reading someone elses formulas though, having the matching brackets coloured accordingly.

This is exactly right!


I need to produce a single printed page containing the 26 summary color-coded formulas. This single page would then be compared to the already printed 26 pages (one for each of the 26 formulas) that shows the color-coded cell borders of the cells related to the particular formula being represented.

Anyway, thanks for everyone's input. I'll move on. I've already spent way too much time in trying to explain WHY.