#1 Roulette Forum & Message Board | www.RouletteForum.cc

Roulette-focused => Outside The Box => Topic started by: gianfrancopierino on Oct 21, 06:10 AM 2021

Title: excel trick, how?
Post by: gianfrancopierino on Oct 21, 06:10 AM 2021
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
Title: Re: excel trick, how?
Post by: Axe Foster on Oct 21, 06:38 AM 2021
Hi,
if this can help....
Title: Re: excel trick, how?
Post by: gianfrancopierino on Oct 21, 07:49 AM 2021
it helps a lot axe foster and thank you.
can you share the process? here o pm
Title: Re: excel trick, how?
Post by: Axe Foster on Oct 21, 07:57 AM 2021
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