I have an office lottery pool. Each of us pick 6 numbers from a range of 1 through 60. This is on sheet1. Sheet2 contains the actual drawn numbers. Rows on sheet2 are labelled by week number. I want all the cells in sheet1 to have conditional formatting that will change the cell color to red if they match any cell from the cells that contain the drawn numbers in sheet2. Can someone please help me on this?
I actually asked this question in a LibreOffice forum because thats what I have at home and thought that maybe it would work for Excel at my work place. But unfortunately the answer I got only works for LibreOffice. I understand that cross posting is frowned upon but I really would like to know how I can get this to work on Excel. Below is what i got to work in the other spread sheet program. I will attache my document without any conditional formatting. Thanks.
Condition 1 Dropdown:
and
SUMPRODUCT(B1=Sheet2.$B$1:$F$52)
Apply Style:
Cell Range
Bookmarks