MrCameronExcel
New Member
- Joined
- Apr 21, 2017
- Messages
- 43
- Office Version
- 365
- Platform
- Windows
Hello,
I would like to apply conditional formatting into a matrix based on multiple criteria and table values.
The below matrix of flat numbers is where I would like conditional formatting applied to. The second table below is where I need to cross reference data.
Criteria:
If the Block (Table 2) matches the Block (Table 1), and the Flat (Table 2) matches the Flat (Table 1 - matrix), then conditional format the flat number in the matrix (Table 1) based on the number in the Helper Column for Conditional Formatting (Table 2).
Any help or pointers is much appreciated!
Thank you
TABLE 1
TABLE 2
I would like to apply conditional formatting into a matrix based on multiple criteria and table values.
The below matrix of flat numbers is where I would like conditional formatting applied to. The second table below is where I need to cross reference data.
Criteria:
If the Block (Table 2) matches the Block (Table 1), and the Flat (Table 2) matches the Flat (Table 1 - matrix), then conditional format the flat number in the matrix (Table 1) based on the number in the Helper Column for Conditional Formatting (Table 2).
Any help or pointers is much appreciated!
Thank you
TABLE 1
Block A | |||||||
Floor | Flat No. | ||||||
1st | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
2nd | 8 | 9 | 10 | 11 | 12 | 13 | 14 |
3rd | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
TABLE 2
Survey | Helper Column for Conditional Formatting | Block | Flat |
No Survey Info | 1 | Block A | 1 |
Potential ACM | 2 | Block A | 2 |
Sufficient Clear | 3 | Block A | 3 |
Sufficient Clear | 3 | Block A | 4 |
Sufficient Clear | 3 | Block A | 5 |
Sufficient Clear | 3 | Block B | 1 |
Sufficient Clear | 3 | Block B | 2 |
No Survey Info | 1 | Block B | 3 |
Potential ACM | 2 | Block B | 4 |
Sufficient Clear | 3 | Block B | 5 |