Colour coding numbers based on entry in another sheet

Copper Contributor


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



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.


This is the range the conditional format applies to.

conditional format.png