Conditional Green Bar formatting

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
Posts: 5
Joined: Mon Jul 15, 2013 9:13 am

Conditional Green Bar formatting

Postby gmue38 » Mon Jul 15, 2013 9:24 am

green bar example.PNG
I have a Jet report that I am trying to format to show and print the results as if it were on green bar paper. The problem I have been encountering is the expanding rows, as the row I wish to format is a sum of two other rows, which are hidden automatically as the report runs. The sum is also hidden in some cases, based on the lines results, so this causes the lines to do the green bar effect every other line in some cases, however in others there will be bunches of white or green lines. Has anyone else used similar formatting or have a way to simulate a green bar effect in a case like this? Any help would be greatly appreciated. Thank you. Gary

Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests