I was asked to repost this question again, so here goes.
How is it possible to format the contents in one column (E), based on the data in 2 other columns (A & C)?
Here is an example of what might be in A & C
A - LTD1
C can have around 20 different leagues. Here's an example
Austria: 2. Liga
Australia: A-League
Bulgaria: Parva Liga
Czech Republic: Czech Liga
Denmark: Superliga
Germany: Bundesliga II
Greece: Superleague
Hungary: NB I
Portugal: Primeira Liga
Portugal: Segunda Liga
Poland: Ekstraklasa
Qatar: Q League
Turkey: Super Lig
What I want is the ability to have the corresponding cell in E change colour based on what shows in A & C
So let's say A10 is LTD1 and C10 is Hungary: NB I, I would want E10 to turn green (RGB 146, 208, 79 which is Hex #92D04F). Since it will not be just a single entry, I assumed just using Conditional Formatting was not an option, but rather VBA.
As indicated, there are maybe 20 leagues just for LTD1. The LTD entries in A go from LTD1 to LTD6, with each having their own set of leagues. Happy to just deal with getting LTD1 right for now, as I can adjust the VBA macro accordingly to create the additional ones required.
So the basic aim is if A contains LTD1 and C contains even just the leagues above, how would I code having E turn green?
Thanks in advance
How is it possible to format the contents in one column (E), based on the data in 2 other columns (A & C)?
Here is an example of what might be in A & C
A - LTD1
C can have around 20 different leagues. Here's an example
Austria: 2. Liga
Australia: A-League
Bulgaria: Parva Liga
Czech Republic: Czech Liga
Denmark: Superliga
Germany: Bundesliga II
Greece: Superleague
Hungary: NB I
Portugal: Primeira Liga
Portugal: Segunda Liga
Poland: Ekstraklasa
Qatar: Q League
Turkey: Super Lig
What I want is the ability to have the corresponding cell in E change colour based on what shows in A & C
So let's say A10 is LTD1 and C10 is Hungary: NB I, I would want E10 to turn green (RGB 146, 208, 79 which is Hex #92D04F). Since it will not be just a single entry, I assumed just using Conditional Formatting was not an option, but rather VBA.
Predictology-Reports Football Advisor.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2923 | LTD2_HOME | 13/09/2022 18:15 | Qatar: Premier League | LayDraw | Al Gharafa - Al Markhiya | ||
2924 | LTD3_AWAY | 13/09/2022 18:15 | Qatar: Premier League | LayDraw | Al Gharafa - Al Markhiya | ||
2925 | LTD2_AWAY | 13/09/2022 19:45 | England: League One | LayDraw | Ipswich - Bristol Rvs | ||
2926 | LTD2_AWAY | 13/09/2022 19:45 | England: League One | LayDraw | Peterboro - Fleetwood Town | ||
2927 | LTD2_HOME | 13/09/2022 19:45 | England: League One | LayDraw | Wycombe - Accrington | ||
2928 | MARIA1_ALTERNATE_HOME_SUMMER | 14/09/2022 11:00 | Japan: J1 League | LayDraw | Kyoto Sanga - Yokohama F. Marinos | ||
2929 | LTD2_HOME | 14/09/2022 20:00 | England: Championship | LayDraw | West Brom - Birmingham | ||
2930 | MARIA1_ALTERNATE_AWAY_SUMMER | 15/09/2022 00:00 | Uruguay: Primera Division | LayDraw | Nacional - Boston River | ||
2931 | MARIA1_ALTERNATE_HOME_SUMMER | 15/09/2022 00:00 | Uruguay: Primera Division | LayDraw | Nacional - Boston River | ||
2932 | LTD1_HOME_SUMMER | 16/09/2022 16:00 | Lithuania: A Lyga | LayDraw | Kauno Zalgiris - Jonava | ||
2933 | LTD1_HOME | 16/09/2022 17:30 | Bulgaria: Parva Liga | LayDraw | CSKA 1948 Sofia - Septemvri Sofia | ||
2934 | LTD6_HOME | 16/09/2022 18:00 | Germany: 3. Liga | LayDraw | Munich 1860 - Erzgebirge Aue | ||
2935 | LTD2_AWAY | 16/09/2022 18:30 | France: National | LayDraw | Dunkerque - Cholet | ||
2936 | MARIA1_ALTERNATE_AWAY | 16/09/2022 18:30 | France: National | LayDraw | Dunkerque - Cholet | ||
2937 | LTD4_HOME | 16/09/2022 19:00 | NL: Eerste Divisie | LayDraw | Zwolle - Den Haag | ||
Lay The Draw |
As indicated, there are maybe 20 leagues just for LTD1. The LTD entries in A go from LTD1 to LTD6, with each having their own set of leagues. Happy to just deal with getting LTD1 right for now, as I can adjust the VBA macro accordingly to create the additional ones required.
So the basic aim is if A contains LTD1 and C contains even just the leagues above, how would I code having E turn green?
Thanks in advance