JorgenKjer
Board Regular
- Joined
- Aug 1, 2016
- Messages
- 65
- Office Version
- 2013
- Platform
- Windows
Hi
Is there anyone who can help?
If the value "X" is one or more times in column B2 to B101, the background color in cell B1 must turn green.
If no "X" in column B2 to B101, the background color must be yellow.
I would appreciate it very much if anyone has a solution
Thanks in advance.
Yours sincerely
Jorgen
Is there anyone who can help?
If the value "X" is one or more times in column B2 to B101, the background color in cell B1 must turn green.
If no "X" in column B2 to B101, the background color must be yellow.
I would appreciate it very much if anyone has a solution
Thanks in advance.
Yours sincerely
Jorgen