K
K
KOToO6OPMOT2021-07-27 20:29:33
Google Sheets
KOToO6OPMOT, 2021-07-27 20:29:33

How to set random colors in conditional formatting?

Good afternoon!
I scoured the internet and, unfortunately, did not find an answer to my question.
The bottom line is this, there is a numbering of parcels 1,2,3 - these are directions and they can be repeated.
I want to make it so that the line is filled with color. For example, packages with number 1 are green, those with number 2 are red (colors do not play a role, full random or some algorithm)

Now:
6100418666ff5771714327.png
I want to make automatic color assignment:
6100423a71a02576176282.png
If you have any ideas, I will be glad to hear!

Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Victor L, 2021-07-27
@KOToO6OPMOT

Through conditional formatting rules

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question