Skip to main content

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




Labels:

Comments

Post a Comment

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

Popular posts from this blog

How to add moving text to Blog or website

In this tutorial i will tell you How to add Moving text or Scrolling text or Marquee text in the Blog. This is moving text Moving Right to Left Code For Simple Moving Text : <marquee>This is moving text Moving Right to Left </marquee> But Simple Moving Text Looks really ugly. To make it attractive,we will add background colour to it by bgcolor="hexadecimal code" . This is moving text With Background Colour Code For Moving Text With Background Colour : <marquee bgcolor="#33cc99">This is moving text with Background Colour </marquee> You will notice that text is not clearly readable. So,we gonna change the colour of the text. This Is Coloured Scrolling Text With background colour. Code For Scrolling Text With Coloured Text & Background. : <marquee bgcolor="#33cc99" style="color:white;">This Is Coloured Scrolling Text With Background Colour </marquee> You can even control the ...
91 comments
Read more

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 ...
66 comments
Read more

Forgot my SBI ATM Pin? Procedure to reset the debit card pin

There are many ways to get a new ATM pin incase you forgot the current one. You can reset it through online banking, through phonebanking or at any of the nearest SBI branch to you 1. Through online banking Visit the onlineSBI portal and go to customer login using your Web Pin. There is an option for ATM Pin reset under the requests tab,, which will help you to generate your new ATM Pin. 2. Through phonebanking You can follow the helpdesk numbers to get the Pin reset over IVR. Here is the number for phone banking - 02227566598 3. Through branch Go to your home branch and submit an application in this regard to get the ATM pin reset. Do carry your original ID proof along for verification purpose. First u have to login personal account>E-services>on the left side click on ATM request >now select ATM pin generation (it will ask for OTP or transaction password) if you have register mobile select OTP and click on continue..50 rupees will be debited from your account..and you subm...
Post a Comment
Read more