March 15th, 2005
We continue our look at the application of conditional formatting in OOo Calc. Here, we wish to apply alternate coloring to even and odd rows. Prior to invoking the conditional formatting dialog, we select all cells in the sheet. This was covered in an earlier tip
The trick here is using the mod function to identify odd rows to which we apply the custom format.
The result after the conditional formatting is applied to the entire sheet.
Here is a Flash animation showing how to do this ….
