dear excel expert,
I want to the cell in yellow under the conditions that the horizontal day (e.g. Fri) match the vertical day (e.g. Fri).
HOW can I do that ?
I want to the cell in yellow under the conditions that the horizontal day (e.g. Fri) match the vertical day (e.g. Fri).
HOW can I do that ?
Book3 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | 9/2 | 9/3 | 9/4 | 9/5 | 9/6 | 9/7 | 9/8 | ||||
2 | ETD | POD | Mon | Tue | Wed | Thu | Fri | Sat | Sun | ||
3 | Fri | NLRTM | |||||||||
4 | Fri | GBSOU | |||||||||
5 | Tue | GBSOU | |||||||||
6 | Mon | NLRTM | |||||||||
7 | Mon | GBSOU | |||||||||
8 | Sat | ESBCN | |||||||||
9 | Sat | ESBCN | |||||||||
10 | Mon | NLRTM | |||||||||
11 | Mon | GBSOU | |||||||||
12 | Thu | NLRTM | |||||||||
13 | Thu | GBSOU | |||||||||
14 | Sat | NLRTM | |||||||||
15 | Sat | GBSOU | |||||||||
16 | Wed | NLRTM | |||||||||
17 | Wed | ITGOA | |||||||||
Sheet1 |