I want to use conditional formatting on column E but I can’t seem to get the formula right. Let me explain what I’m trying to achieve with an example.
I have 2 sheets in the same workbook. On sheet 1 in column D I have the product codes and in column E I have a value (Both columns have text).
Then on sheet 2 I have a product reference list. Column A has the product codes and Column C then has a value (Again both columns have text). The same products in both sheets should have the same value in column E(sheet 1) and C(sheet 2).
What I’m trying to format is column E on sheet 1. I want it to fill orange if the value is not the same as the corresponding product on sheet 2 in the C column. Need help with the formula.
I hope this has been clear enough to understand.
I have tried using the =COUNTIF() function but cant get it to work with this.
Thanks in advance for any help.
Bookmarks