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
like this? I can't understand what you mean exactly!
Cosi?
Finales RF.xlsx
I hope this helps
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
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?
i need auto'd, a lot of groups
if in a cell appears an extracted number, that cell must be flagged in some way.
Hello & good day! Is it OK for this to be done as a traditional program instead of Excel?
Cheers!
it's ok, the important part is for me to be able to insert the groups i need
It's super easy. Just explain exactly what you are looking for.
Cheers or explain what you need exactly.
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
Quote from: gianfrancopierino on Sep 21, 05:05 PM 2022it'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/
Display_Numerical-group-highlighter.png
Display_Numerical-group-highlighter_2022-10-18.png
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) :thumbsup: