lottery worksheet?

  • Thread starter Thread starter roblobster
  • Start date Start date
R

roblobster

I'm having difficulty creating a lottery worksheet or I just lack
creativity.

What I thought I could do was set "Conditional Formatting" (e.g.. if A1=$H$1
or $I$1 or $J$1 or $K$1 or $L$1 then highlight)
But it won't let me reference to a range.

Does anyone have any possibilities?

Thanks for your input.
 
You want your conditional formula in a cell to read
something like this:

If(or(A1=$H$1,A1=$I$1,A1=$J$1,A1=$K$1,A1=$L$1),true,false)

I'm not sure of what logic your trying to workout but
replace the true and false arguments above with whatever
results you want returned given the outcome. There is
another way choosing through a list of options that might
be better if your looking at an extensive list of
comparison values or cells.

Hope this helps.
 
That's awesome. Thanks all.


Dan E said:
Put,
=OR($A1=$H1,$A1=$I1,$A1=$J1,$A1=$K1,$A1=$L1)
As your condition (Formula Is)

or you could add another column with the formula
=OR(A1=H1,A1=I1,A1=J1,A1=K1,A1=L1)
Then Highlight if it's True

Dan E
Click to expand...
 
Just another option. If you have a range of the winning numbers...

=MATCH(A1,WinningNumbers,0) >0
 
Back
Top