I want to highlight cells based on a set of values that is made from a formula. I have the data in the sheet from
A2:D10 (can be text, numbers, anything). I have compared this data with another sheet using formulas and have the text as
different in cells
Now I need to highlight the data available in cells
A2:D10 based on the values in
E2:H10. For example if the data in cell
Different, I want it to highlight the cell
C3 as 'red' and cell cell
same, I want it to highlight the cell
A2 as 'Green'.
I tried to accomplish this with conditional formatting, but it doesn't seem to work properly. Any ideas? Can we accomplish this with conditional formatting or with VBA?