Hello I need help with creating a formula in Excel.
Worksheet 1:
It is a table containing a list of candidates and their relative information. The important columns for this problem are 'J' (Time Zone) and 'N' (IP Country).
Worksheet 2:
It is table with two column containing Time Zone and the correct Country.
Problem: In the Table, there are some candidates whose IP country doesn't have the correct Time Zone, and I would like to flag these rows by changing the color of the entire row to RED.
Worksheet 1:
It is a table containing a list of candidates and their relative information. The important columns for this problem are 'J' (Time Zone) and 'N' (IP Country).
Worksheet 2:
It is table with two column containing Time Zone and the correct Country.
Problem: In the Table, there are some candidates whose IP country doesn't have the correct Time Zone, and I would like to flag these rows by changing the color of the entire row to RED.
- I am looking for a formula to use each cell in Table 1, column N.
- Next, the country name in that cell of Table 1 is a look-up value to match it to the country name in Table 2. In Table 2 a country name may have multiple time zones
- After matching the country name between the two tables, if that specific row in Table 1 column J 'Time Zone' doesn't have any of the corresponding Country Names based on Table 2 data, then highlight that row in Red, preferably in any form of highlighting.