Need a insert a empty cell if compare different function

Greetings Peers,

I am new to this forum. I have read thru the forum anything near to my
topic, but i still dont understand anything. If any kind peers out
there willingly to teach me step by step. Your help will be
appreciated. Thanks in advance. here goes, This is wat i need in my
excel :

Firstly,I want to compare at least 4 columns of data.

EG:
c1 c1 c1 c1
c2 c2 c2 c3
c3 c3 c3 c4
c4 c4 c5 c5

When there is a difference in the column i wish to insert a empty cell
in that column only and colour the empty cell.Like there is a
difference in the column 4 , C2 is missing and column 3 , C4 is
missing.


--
saici

Isn't there anyone who can help me?

saici Wrote:
> Greetings Peers,
>
> I am new to this forum. I have read thru the forum anything near to my
> topic, but i still dont understand anything. If any kind peers out
> there willingly to teach me step by step. Your help will be
> appreciated. Thanks in advance. here goes, This is wat i need in my
> excel :
>
> Firstly,I want to compare at least 4 columns of data.
>
> EG:
> c1 c1 c1 c1
> c2 c2 c2 c3
> c3 c3 c3 c4
> c4 c4 c5 c5
>
> When there is a difference in the column i wish to insert a empty cell
> in that column only and colour the empty cell.Like there is a
> difference in the column 4 , C2 is missing and column 3 , C4 is
> missing.


--
saici

Are the values always incremental (1,2,3,4, etc), or do they jump around?

You do not have to check all 4 columns, just look at the sequence in any given column for a skipped value.