[Solved] Set cell colors based on dropdown selection

[eeigor]

I just tried to point out that someone who calls himself "Noobian" may not be able to transfer a given solution.

Perhaps Noobian in the game, not in Calc. And that's none of our business. I don't play at all.

But it was offered quite a ready-made solution. Problems will arise in editing the ranges. I had a specific question for you @Villeroy. Do you have an opinion?

Edit:
Cross ref posted

[karolus]

Hallo
No need for INDIRECT, only with 2 Named-Ranges

Cyberpunk_karakterlap_no_indirect.ods

(25.6 KiB) Downloaded 86 times

[eeigor]

No need for INDIRECT

There is a need. Calc is being tested for strength.
These are variations (your solution). The problem has already been solved. There is a tutorial attempt to remove the auxiliary sheet. But there was no way...

[Noobian]

well Noobian is just a username i came up with, but to be fair, my skills are not as high as you guys. This is the intention behind this little project, to train myself and to get better. Before i was given the example solution, I thought its enough for me to set a cellstyle, and in the conditional formatting to select the cells i want to get highlighted. My confusion came, when I had to setup "cell value" or "all cell". Im using the hungarian version, so i don't know how it is called exactly in english. But eeigor and Zizi64 showed me solutions, but the whole things needs more complex things than i was hoping for

[Noobian]

thanks Karolus! I wish i understand how you guys are doing all these things but time is on my side. I will get it work. Now Zizi64, eeigor and Karolus showed me different variations for the same thing

[eeigor]

Use my way. @karolus refused to use INDIRECT() because it is volatile (gets updated whenever something changes). But my solution is simpler, and the overhead caused by using INDIRECT() is negligible because you have little data.
You cannot use named formula expressions. Only in the way I suggested (with named ranges).

[Villeroy]

This whole project is doomed to fail unless you use a true database. In 30 years I have not seen anything like this working on sheets. As soon as you add more items, properties, subitems, subproperties etc. the whole spreadsheet becomes unmanagable because spreadsheet programs are arithmetic calculators in the first place. Most of the functionality is about arithmetics and and a comparatively small subset of features tries to mimic a simplistic database program with some flat list keeping capabilities.99% of new users project a database onto the grid of cells and don't care about the core functionality.

[eeigor]

Test. Excel INDIRECT() test to work with named formula expressions fails. It does not work either. The question is closed.
All that I suggested to the author is the solution.

[eeigor]

@Noobian, an error has been corrected:
Technikus: Cyber tech. This skill has not been highlighted.

[Noobian]

ok thank you guys for your kind help! I really appriciate it!