« Using Pop Up Notes in Cells | Main | Basic functions: CHOOSE »

September 12, 2005

Checkerboard shading

A checkerboard shading effect is easily achieved with conditional formatting as shown below. The conditional formatting dialog is invoked with Format - Conditional Formatting

Please review earlier articles on conditional formatting here , here and here.

When the condition (formula) evaluates to true, then the specified style is applied to the cell. We have seen this before. ISODD is a boolean function so is ideal in this situation.

shading_3.jpg


The resulting pattern...

shading_4.jpg

Posted by Dave at September 12, 2005 08:38 PM

Comments

Post a comment




Remember Me?