« Conditional Formatting II | Main | Basic Functions: FREQUENCY »
March 15, 2005
Conditional Formatting III
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 tipThe 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 ....
See also:
Conditional Formatting II
Conditional Formatting I
Selecting an entire sheet
Posted by Dave at March 15, 2005 04:02 AM