Excel auto sequence numbering

[RJ1969]

Hello all,

Trying to figure it out how to set an auto number in the worksheet i am working on without using vba code.

Here is my scenario.,,
Let say the number 1 starts in column A5. Which i have type that #1 in the cell A5 then an entry will be made in column B5. Now if i make my next entry then the #2 in B6 will auto number if i make an entry in B6. I don't need to enter the number which is just automatically numbering the cells everytime i do an entry. My worksheet is set "clear print area". It only unclear where the entry is being made. So that is why i am trying to avod putting a code in column A on a cells.
I dont know if this can be done in conditional format.

Thanks you

 

[Michael M]

Type the 1 in A5
In A6 put the formula

=IF(AND(A5<>"",B5<>""),A5 + 1,"")

and drag down as required

 

[RJ1969]

Hi Michael
Can this be done in conditinal dormatting? Im trying to avoid putting formula in cell A6 all the down because of a printing purposes.