odd row in % and even row in number format

[VBABEGINER]

Hi Team,

How do I achieve this,
all Col A odd row nos in % format and even row are in number format..

Thanks..

 

[Special-K99]

Select the range

Conditional Formatting
New Rule
Use a formula to determine...

2 formulas required

=MOD(ROW(),2)=1 format as Number percentage
=MOD(ROW(),2)=0 format as Number

 

[Joe4]

Use Conditional Formatting.

Select all the rows, then go to Conditional Formatting and add these two rules.

Rule 1: Add the following CF formula:

=ISODD(ROW())

and choose the percentage format option

Rule 2: Add the following CF formula:

=ISEVEN(ROW())

and choose the number format option

 

[VBABEGINER]

Hi K99, Thanks for providing the solution.. I tried but m not getting, may b'coz i properly not understand's..

Hi Joe, Thanks for providing the solution.. It works and pretty simple for me to understand..

 

[Special-K99]

=MOD(ROW(),2)=1

Takes the row number and after dividing by 2 if the remainder is 1 then it is an odd row, if it is 0 then it is an even row.
So you format the cell depending on the remainder being 1 or 0.

Maybe it needs to be this

=(MOD(ROW(),2)=1)
and
=(MOD(ROW(),2)=0)

Not really much different to the other solution provided.

if you put the =(MOD(ROW(),2)=1) formula in a blank cell and copy down the column it should say TRUE FALSE TRUE FALSE TRUE FALSE indicating odd and even rows.