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
=Mod(column(),2)

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




learn periodic table in hindi

H
LI
Na
K
Rb
Cs
Fr

Rhyme:
1.Hamari lina kabr se farar
2.hai lina ki rab se fariyad

Be
Mg
Ca
Sr
Ba
Ra

Rhyme: beta maange car scooter baap roe


sc-science
ti-teacher
v-very
cr-cruel
mn-maange
fe-fair
co-copy
ni-nickel
cu-copper
zn-zinc

Rhyme-
1.science teacher very cruel maange fair copy nickel copper zinc
2.Still  Trying Various Creative Methods For Controlling Naughty Children Zinc

y-ye
zr-zara
nb-nai
mo-modern
tc-technology
ru-
rh-
pd-
ag-agriculture
cd-cdma
Rhyme:ye zara nai modern technology ........................................… cdma

la-laa
hf-haf
ta-ta
w-wo
re-rahi
os-oos
ir-idhar
pt-phata
au-udhar
hg-hata
Rhyme-la haf ta wo ree oss idhar hata udhar phata

b-ba
al-el
ga-gai
in-in
ti-tabela
Rhyme-bael(bull) gai(cow) in tabela

c-ca
si-si
ge-gae
sn-sunn
pb-pade
Rhyme-kaashi(religious place) gae sunn(fainted) pade

o-aur
s-sahi
se-se
te-te
po-po
Rhyme-aur sahi se tepo(cheat)

f-far
cl-cal
br-bara
i -i
at-hat
Rhyme-farcal barai hat