Originally Posted by saici

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.