Hello

I have a question how to create absolute cells in column C which has formula to compare compare A cell and B cell.
For example, A1 is compared with B1. C1 has the formula i.e. C1 = IF(A1=B1, "yes","no"). Data continues from Row 1 to let say down to 1000.
copying C1 to all the way down to C1000.

But now the challenge is, i need to insert or delete cells in A column or B column randomly which changes the C reference cells.
So making them absolute i.e. C1=IF($A$1=$B$1, "","") C2=IF($A$2=$B$2, "","") ....C1000=IF($A$1000=$B$1000,"","") is what I want to do.
It can be done easily for a few cells, but if there are thousands of cells, how can I create ?

Thank you
Samky2005