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 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 ….
See also:
Conditional Formatting II
Conditional Formatting I
Selecting an entire sheet
October 30th, 2007 at 2:44 pm
thank you!!!! I had searched for over an hour and couldn’t put this together. Your animation is very helpful.
Only thing I would change is to slow down the part where you enter the formula. I had to watch it a couple of times to get the keystrokes necessary.