Martin_H
Board Regular
- Joined
- Aug 26, 2020
- Messages
- 190
- Office Version
- 365
- Platform
- Windows
Hi team,
let there be a range L4:L126.
In this range, the cells can only acquire the values W4, or W5, or W6, or W7, or JR, or the cell is just empty.
If the cell in the range - let's just say L6 - has a value W4, then color the font of the cell C6 to RGB(0, 130, 59) else,
If the cell in the range - let's just say L8 - has a value W5, then color the font of the cell C8 to RGB(0, 0, 0) else,
If the cell in the range - let's just say L25 - has a value W6, then color the font of the cell C25 to RGB(255, 0, 0) else,
If the cell in the range - let's just say L111 - has a value W7, then color the font of the cell C111 to RGB(128, 10, 246) else,
If the cell in the range - let's just say L87 - has a value JR, then color the font of the cell C87 to RGB(128, 0, 0) else,
If the cell in the range - let's just say L120 - is BLANK (empty), then color the font of the cell C120 to RGB(191, 191, 191) end.
Thank you for your help.
Much appreciated.
let there be a range L4:L126.
In this range, the cells can only acquire the values W4, or W5, or W6, or W7, or JR, or the cell is just empty.
If the cell in the range - let's just say L6 - has a value W4, then color the font of the cell C6 to RGB(0, 130, 59) else,
If the cell in the range - let's just say L8 - has a value W5, then color the font of the cell C8 to RGB(0, 0, 0) else,
If the cell in the range - let's just say L25 - has a value W6, then color the font of the cell C25 to RGB(255, 0, 0) else,
If the cell in the range - let's just say L111 - has a value W7, then color the font of the cell C111 to RGB(128, 10, 246) else,
If the cell in the range - let's just say L87 - has a value JR, then color the font of the cell C87 to RGB(128, 0, 0) else,
If the cell in the range - let's just say L120 - is BLANK (empty), then color the font of the cell C120 to RGB(191, 191, 191) end.
Thank you for your help.
Much appreciated.