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 ...
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
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.
- Thank you for your reply.
- 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 meSorry, I have no other ideas and VBA is not my territory either. If go this way perhaps someone else could help.
