Forum Discussion
1TOMYK11
May 18, 2022Copper Contributor
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 ...
PeterBartholomew1
Silver Contributor
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?
1TOMYK11
May 18, 2022Copper Contributor
)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