excel needed to test system

[gianfrancopierino]

Hi guys, I need excel help.
In the attached file, there are many groups of 8 numbers in COLUMN A

my request with example:

- number 7 is extracted
- is insert number 7 in COLUMN B
- all the groups containing 7 (non 17 and 27, only 7) must receive a red (any color is ok) background or the text must receive a color
- numer 23 is extracted, and so on and on

can anyone help me?
tks

[ᶦ ᵃᵐ|Ä-łëx]

like this? I can't understand what you mean exactly!

[Bigbroben]

Cosi?

[Kimo Li]

Finales RF.xlsx

I hope this helps

[gianfrancopierino]

alexlaf, Bigbroben got it right, but not yet automated

Bigbroben like that, but the moment i insert a number it should be automatic

Kimo Li i can't understand how to use your excel file

[Bigbroben]

Ok...
what needs to be auto'd?
you want all the highlighted nrs to appear on a single line?

To you want simply to write the spun number and delete the old one or you want them to be remembered in a column?

[gianfrancopierino]

i need auto'd, a lot of groups
if in a cell appears an extracted number, that cell must be flagged in some way.

[VLS]

Hello & good day! Is it OK for this to be done as a traditional program instead of Excel?

Cheers!

[gianfrancopierino]

it's ok, the important part is for me to be able to insert the groups i need

[Bigbroben]

It's super easy.  Just explain exactly what you are looking for.

[ᶦ ᵃᵐ|Ä-łëx]

Cheers  or explain what you need exactly.

[Kimo Li]

The spreadsheet is designed to convert spins into finales.
Then the user can highlight the finales and do a conditional formatting.
In this example, the condition was to highlight finale 4, color pink if equals 4


Finales RF Conditional Formatting.xlsx

[VLS]

it's ok, the important part is for me to be able to insert the groups i need

Hello, your request is being honored with the new Numerical Group Highlighter module:

Link: rouletteideas.com/ribot-discussion/numerical-group-highlighter-module/

Download page: rouletteideas.com/downloads/

[VLS]

BTW, the auto-saving code is done so new version remembers font style, font color, highlight color and the last numerical group list on screen (saved on close)