# COLOUR MARKING OF THE MATCH SCORE

Copper 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 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

9 Replies

Like this?

# Re: COLOUR MARKING OF THE MATCH SCORE

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 realistic

thx

# Re: COLOUR MARKING OF THE MATCH SCORE

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.

# Re: COLOUR MARKING OF THE MATCH SCORE

- there are a lot of combinations, I probably wouldn't be able to match 1:1
- VBA, you mean macros? I'm not familiar with that at all.

Sorry, I'm not an excel spreadsheet specialist, I just had this idea, but probably unrealistic for me

# Re: COLOUR MARKING OF THE MATCH SCORE

Sorry, I have no other ideas and VBA is not my territory either. If go this way perhaps someone else could help.

# Re: COLOUR MARKING OF THE MATCH SCORE

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?

# Re: COLOUR MARKING OF THE MATCH SCORE

I guess it shall be different color for each of i-j combination.

# Re: COLOUR MARKING OF THE MATCH SCORE

)@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

# Re: COLOUR MARKING OF THE MATCH SCORE

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)