Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
I have a list of rankings in Column AB and I have ranked by a group in column L
My formula is - COUNTIFS($L$12:$L$100000,$L12,$Y$12:$Y$100000,">"&$Y12)+1)
Column Y is what it is ranking on
which all works spot on.
What I would like to do is show the red to green for each ranking within the group, at the moment it uses all the rankings on the red to green.
Is it possible to achieve this by using conditional formatting?
Thanks for any help you are able to give me.
My formula is - COUNTIFS($L$12:$L$100000,$L12,$Y$12:$Y$100000,">"&$Y12)+1)
Column Y is what it is ranking on
which all works spot on.
What I would like to do is show the red to green for each ranking within the group, at the moment it uses all the rankings on the red to green.
Is it possible to achieve this by using conditional formatting?
Thanks for any help you are able to give me.