excel trick, how?

[gianfrancopierino]

hi guys attached is an excel file

i need an automatic way to put a green background when the same split repets itself in the column, in the file E2 and E3

manually is a lot of work
tks guys

[Axe Foster]

Hi,
if this can help....

[gianfrancopierino]

it helps a lot axe foster and thank you.
can you share the process? here o pm

[Axe Foster]

just go to "Conditional Formats" and write this formula: =IF(E3=E2;1;0)
Then choose the appropriate color
Remainder to be reported on all columns