if then formula for alternating colors in crystal reports

Click OK to close the Conditional Formatting dialog.Choose a light green (or light blue or light yellow) pattern.In the Format Cells dialog, Click the Patterns tab.Enter this formula in the Formula box: =MOD(ROW(),2)=0.In the Conditional Format dialog, change the first dropdown from 'Cell Value Is' to 'Formula Is'.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.

If then formula for alternating colors in crystal reports