match & highlight

So i have a list of say 10 players down column 'A' To the right of these names there are 6 numbers ranging from 1-59 in separate cells (columns B, C, D, E, F, & G) Somewhere else in the spreadsheet, i want to put the recent lottery results (drawn twice per week) which will consist of 6 numbers...

Hi Guys, Does anyone know how I can lookup the values in one row in sheet 2 and compare this with all rows in sheet 1? If any of the cell values in one row (from cells A2 to BB2) in sheet 2 equal the values in any of the rows in sheet 1(from cells A2 to BB2) then I would like to return the...

Hi there. So, I get the following situation: LINK TO IMAGE I need to see all the values on column D (specific transactions ID) on column A (Transaction ID) so I can sum the amounts and get a total from the specifics transactions. I already tried conditional formatting for highlighting all the...

My objective is to establish a conditional format across the table based on a certain threshold establish for multiple categories. Each category will have a different threshold, which adds another layer of complexity to the issue. Below is an example breaking it down. Feel free to ask what ever...

In Table 1 (V53:Y62), I want to put back ground color using CF for those value which EQUALS column MA (MA53:MA62) Sheet2 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...

Hello! I have a spreadsheet that is supposed to contain only entries of tests taken at a certain school, but some students are showing as having taken a test at a different school. I would like to highlight the few students' schools when the names don't match the desired school name. Example...

Hey guys.. I need some help So sheet 1 has the below data Cell A2, A3 and A4 have 1, 2, 3 respectively and Cell B1, C1 and D1 have 2, 3, 4 respectively I want excel to highlight matching cells in B1, C1 and D1 by searching A1,A2 and A3 Is there a formula or macro that can do that?

Hello, I have a problem that I need some help with. I have data in 2 columns and I need to highlight all the amounts that match the list, looping down the list each item at a time, and once the amount is matched (paired) to continue the loop but disregard the paired (matched) items; even if the...