kingsushi001
New Member
- Joined
- Oct 24, 2017
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
Hi Everyone
I seem to be having problems and I just can't figure it out. Been googling a few days now without any clear answer.
I have this sheet:
The Colors in column A are pulled from an array (color) on this sheet:
Now my problem is that I need the HEX corresponding to the color in A from the array to be in column B, but seeing as column A is random, the HEX column gets all messed up and I have no idea how to fix it.
My second problem is that it needs to be done for Primary Color/HEX AND Secondary Color/HEX, except that the values for Secondary Color cannot be the same as for Primary Color.
Meaning that if for instance A2 is Green, the value for C2 can't be green as well, it needs to either choose the next value in line, or a new random one.
If anyone can help me out with this, it would be greatly appreciated as I'm losing sleep over this ?
I seem to be having problems and I just can't figure it out. Been googling a few days now without any clear answer.
I have this sheet:
ColorsExample.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Primary Color | Primary HEX | Secondary Color | Secondary HEX | ||
2 | Magenta | |||||
3 | Green | |||||
4 | Red | |||||
5 | Yellow | |||||
6 | Yellow | |||||
7 | Blue | |||||
8 | Green | |||||
9 | Red | |||||
10 | Yellow | |||||
11 | Red | |||||
12 | Blue | |||||
13 | Green | |||||
14 | Yellow | |||||
15 | Yellow | |||||
16 | Magenta | |||||
17 | Magenta | |||||
18 | Blue | |||||
19 | Cyan | |||||
20 | Red | |||||
main |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:A20 | A2 | =INDEX(color,RANDBETWEEN(1,ROWS(color)),1) |
The Colors in column A are pulled from an array (color) on this sheet:
ColorsExample.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Colors | HEX | ||
2 | Blue | 0000FF | ||
3 | Cyan | 00FFFF | ||
4 | Green | 00FF00 | ||
5 | Magenta | FF00FF | ||
6 | Red | FF0000 | ||
7 | Yellow | FFFF00 | ||
col |
Now my problem is that I need the HEX corresponding to the color in A from the array to be in column B, but seeing as column A is random, the HEX column gets all messed up and I have no idea how to fix it.
My second problem is that it needs to be done for Primary Color/HEX AND Secondary Color/HEX, except that the values for Secondary Color cannot be the same as for Primary Color.
Meaning that if for instance A2 is Green, the value for C2 can't be green as well, it needs to either choose the next value in line, or a new random one.
If anyone can help me out with this, it would be greatly appreciated as I'm losing sleep over this ?