Conditional formatting to colour rows/columns

**Bekanator** · 11-07-2006, 09:20 PM

I'm having troubles trying to colour my cells so that all the even-numbered cells are yellow and the odd cells are white.

All the tutorials I've seen only show me how to make a formula so that a cell is a certain colour if the data in it is high, low, more than, less than, etc.

How can I format my table so that even and odd rows/columns are just a certain colour?

**mangesh_yadav** · 11-08-2006, 12:35 AM

Select all the cells, go to conditional format, select FORMULA IS, and enter the formula:
=mod(row(),2)=0

choose the required format color (yellow) by clicking on format button, pattern.

**mangesh_yadav** · 11-08-2006, 12:40 AM

Select all the cells, go to conditional format, select FORMULA IS, and enter the formula:
=mod(row(),2)=0

choose the required format color (yellow) by clicking on format button, pattern.

**Bekanator** · 11-10-2006, 07:01 PM

Thanks, the formula works perfectly.

However, if I wanted to change it so that the ODD-NUMBERED cells are coloured, how to I alter the formula?

Also, how do I do this with columns?