numbers

Hello all, 1st time posting in apple discussions. Always used excel but awaiting delivery of an Apple air15 so will be giving Numbers a whirl.

Basically in work we have a weekly football competition where we predict scores and I use excel for this.

I have a column with say “Arsenal” at the top. I put each persons guess how many goals Arsenal will score in that column and at the bottom I put the actual amount of goals Arsenal scored.

If someone guessed correctly the cell turns green. Simple as that.

I have borrowed my sons iPad and have had a play and can do this 1 cell at a time but can i conditional highlight a whole column at once ?

So the cell changes colour to green if say

A2 to A20 match A22

I am going to attempt to replicate my excel sheet in numbers and have roughly 5 weeks to do this.

Cheers