Hey!
I was hoping to get some help on a formula. I am trying to make my life easier when checking lotter tickets for winning #'s by having excel changing the cell color when the value matches the listing of winning numers.
In my attachment I am going to type the winning numbers in row 4
I would like a formula that will change the color of the a cell to yellow if the value in the cell matches A4, B4, C4, D4, E4.
Once I get that formula I will need to change it to be specific to look only for the powerball for column F.
I'm running a work pool and would love this to make it easier to check numbers.
Thanks in advance for your help!!
Doug
Bookmarks