Colour Alternate row or column in Excel 2007

Select the rows & column where you want to make change.
To make changes to the whole document
Hit ctrl+A
1. Go condition Formatting  and Click on New Rule

2. Click on Use formula to determine which cells to format

3. Type the formula =mod( row(),2)
4. Click on format and select your desired color.

5. Out put will be like this

 To Colour alternate column use below formula at step 4

Output will be like as shown in pic in left

To make Chess like cell
Use below formula in Step 4
=Mod(row( ),2)=Mod(column( ),2)
Out put will be like

No comments:

Post a Comment

If You Like The Post Or want to Add Something More
then feel free to comment