Help identify column differences

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

Hi

I have a spreadshheet with 2 of the columns
being "Interest Paid" & "Interest Due". I need to add a
formula that will show me where the two columns have
different values or the same values. For instance, if
Interest due is 400 & interest paid is 400, I would like
the cell next to it to say, "DELETE". If however the
Interest Due is 400 and Interest Paid is any other amount
other than 400, I would like the cell next to it to
say "KEEP" and, if possible, formatted to be RED.

Many thanks

Malcolm Davidson
 
With one set of data in Col A and another in Col B, in C1 put:-

=IF(A1=B1,"Delete","Keep") and copy down.

Now select Col C and do Fornat / Conditional formatting / Cell Value 'is equal to' Keep

Hit the format button and choose a red pattern with a white font.
 
Back
Top