Forum Discussion
COLOUR MARKING OF THE MATCH SCORE
Hello
I would like to ask you if it is possible to colour code the result in the table
For example
in cell A1 I have the result 2-4
in cell A2 I have a value of 1-5 - win - colour green
in cell A3 I have a value of 5-1 - loss - colour red
in cell A4 I have a value of 2-4 - exact result - colour yellow
Thank you very much for your answer
9 Replies
I think the problem needs to specified more closely. What sort of 'matches' are we discussing and what is the possible range of results? At the moment, I do not understand the rules for colouring well enough to perform the task by hand using highlighters so I would not know what rule to implement for conditional formatting. For example, why isn't 2-4 green? What distinguishes it from 1-5?
)PeterBartholomew1 It's basically like a sporting result... 2-4 is the actual value(result), the others are types for the exact result - the colors are not fixed, can be anyfor example:result 2-4 - cells where the values 2-4= 100%matchcells where the type is for example 5-1 wrong type cells where the type is for example 3-4 correct type (colour coded
I guess it shall be different color for each of i-j combination.
- It's basically like a sporting result... 2-4 is the actual value(result), the others are types for the exact result - the colors are not fixed, can be anyfor example:result 2-4 - cells where the values 2-4= 100%matchcells where the type is for example 5-1 wrong type cells where the type is for example 3-4 correct type (colour coded)
Hello, Peter
Thank you for your reply. I spelled it wrong. I have more and different results, e.g. see below
This would have to be a rule for all possibilities, which is not realisticthx
IMHO, there are two possibilities
- assign color for each possible combination of numbers and manually as many conditional formatting rules as colors you have
- define formal logic which combination of numbers will have which colors (in RGB) and use VBA programming to apply such logic.
