From the menu, select Format > Conditional Format.Method 2 Use Conditional Formatting Using Conditional Formatting After sorting the above data by customer, the nice pattern of 2-green followed by 2-white is a haphazard pattern of green and white: The disadvantage of this method is that as you sort the data, the formatting travels with the original row. Click OK.Įxcel will apply a greenbar effect as shown: Use the scrollbar to slide down to the third page of formats. In the AutoFormat dialog, you will see 6 formats.From the menu, select Format - AutoFormat.Method 1 Use AutoFormat AutoFormat Settings Window
This article will discuss three options for applying greenbar formatting to a report. It is also still easier to follow the lines across the page. Using Greenbar formatting in Excel has a nice retro look. These reports had 132 characters across, and being able to follow the colors across helped you to keep your place on the report. Four rows were shaded in green, then four rows were shaded in white. These reports always printed on paper called 'Greenbar'. If you are over a certain age, you will remember when all computer reports were produced by the MIS department using COBOL and a high-speed IBM Line Printer.
