Forum Discussion
Colour coding numbers based on entry in another sheet
Hi
I run a Pub Lottery Game, and was wondering if someone could help with some formatting of cells.
So, each player picks their 8 numbers and then based on the weekly lottery draw if their number comes out it gets marked off.
What I am trying to do is as I enter the weekly draw numbers in one sheet that it automatically colours them on another sheet, so I don’t miss any.
is there a way to do this, as I have searched all over and not been able to find a formula that works.
1 Reply
=COUNTIF($K$2:$R$2,B3)This rule for conditional formatting returns the intended result if i correctly understand what you are looking for. The draw is entered in range K2:R2 in my example.
=$B$3:$I$18This is the range the conditional format applies to.
