Conditional Formatting - EQUAL

Hi guys,

I've been searching for appropriate thread but couldn't find it. I have a problem with conditional formatting as follows:

- Is it possible to make conditional formatting like if we have equal cells between each other, highlight the cell with green color. So, what I mean is that conditional formatting works like EQUAL TO but I do not have values for comparison. Cells for comparison are between each other. That means that if we have for example cells in first raw A1=F1=W1, highlight them with green color.

Can anyone help?

Thanks for your reply, TMS.

I've solved it but not with your formula. I've tried with your formula but couldn't solve it. Then, I've seen option to make New Rule for Conditional Formatting. If we make new rule, we have an option 'Format if cell is unique or duplicate'. With this option is possible to do it.

However, to raise up this task, do you have any idea to do following:

- Lets say that we have cells A1, B1, C1, D1, E1, F1. And values in the following cells are equal A1=B1=F1 and C1=D1. Is it possible to conditionally format this situation like A1,B1,F1 to be darker green and C1,D1 to be lighter green because in first point we have three cells equal and in second two (just to mark different groups of equal cells).

Example for formatting.xlsxGuys, guys, guys...

all above is cool for particular cells. Thank you for your solution, I haven't used digital logic in Excel till now.

However, lets rise up a this situation and make universal solution for this point. What will we do if we have basically matrix (rows and columns) where we should make same algorithm of formatting? Please find attached example for formatting and please give me extensive explanation. Please note that I am not Excel professional.

Yeah TMS, you are right.

But please explain me what to do what I have for example 300 rows? Does it mean that I have to select/copy/paste formula for each row or there is some easier solution?

Dear guys,
I see that maybe I am not clear. Please find attached original file for the analysis. So basically I have 6 groups of values. Each group has the same title rows (highlighted with yellow color). Now, I need conditional formatting of the corresponding columns: comparison of d1 with d1 of each group (ROW BY ROW), then b with b (SAME), c1 with c1 (SAME), etc. BUT, Important is that there is NO mixing between columns. I mean d1 MUST NOT be mixed with e.g. c1 and similar, only corresponding of the other group.

This is the problem that I have guys and I really don't know how to do this on the easy way.

Please help.


Original example.xlsx