Hi from partially cloudy 9 Degrees C York UK,
I am struggling with conditional formatting. This is what i want to achieve..
Phrase "Hotels York" - Wk 1 Position 5 | Wk 2 Position 1 - (Promotion Green Arrow Up)
Phrase "Bed & Breakfast York" - Wk 1 Position 2 | Wk 2 Position 2 - ( No movement Flat yellow Bar)
Phrase "Santa York" - Wk 1 Position 1 | Wk 2 position 5 (Demotion - Red arrow pointing down)
Here is an illustration of the data I'm working with, highlighted in yellow is the data area i'm working with.
https://drive.google.com/file/d/1fIIlpt6_uR34suHERgPf7fFXSQLU5k8d/view?usp=sharing
Thanks in advance,
David
I am struggling with conditional formatting. This is what i want to achieve..
Phrase "Hotels York" - Wk 1 Position 5 | Wk 2 Position 1 - (Promotion Green Arrow Up)
Phrase "Bed & Breakfast York" - Wk 1 Position 2 | Wk 2 Position 2 - ( No movement Flat yellow Bar)
Phrase "Santa York" - Wk 1 Position 1 | Wk 2 position 5 (Demotion - Red arrow pointing down)
Here is an illustration of the data I'm working with, highlighted in yellow is the data area i'm working with.
https://drive.google.com/file/d/1fIIlpt6_uR34suHERgPf7fFXSQLU5k8d/view?usp=sharing
Thanks in advance,
David