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 ...
=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.