Currently I'm creating a database for models and I want some automation in it.
I know how to do some conditional formatting but not that extensive.
So what I want to do:
The models are divided in 2 groups; fashion and commercial. They belong to one group depending on their height.
And the height requirement is different for each gender.
So basicly:
If a model is female and 175 or heigher, I want her length to be green and her group to be Fashion
If a model is female and below 175, I want her length to be regular and her group to be Commercial
If a model is male and 184 or heigher, I want his length to be green and his group to be Fashion
If a model is male and below 184, I want his length to be regular and his group to be Commercial.
So; I want the cell of the height to change depending on it's own value, which is above 175 for female and 184 for male but also on the value of the gender. So that it wouldn't turn green for males on 175.
And I want the cell of the group to change the name depending on wether the background of the height is green, if that's even possible.
Could any of you help me out?
The colums; B is for the gender, J is for the height and V is the group
Bookmarks