Get instant live Excel expert help to learn how to highlight a cell in Excel

I have two very large sets of numerical data on the same excel file but on two different sheets and I need to compare them and highlight any differences. Data Set number 1 is all just in one column, But data set number two is also in one column but there is a lot of other data that is not relevant. I used a pivot table, to sum up all of the numbers I needed in Data set 2 and then I summed up the numbers in data set 1 and there was a difference so I need to have excel highlight that difference

Trying to search column cells for duplicates based on first 7 characters. Then highlight the duplicates.

I need to highlight dates in a column, whenever the date in a cell is less then 7 days away from the date of the cell above. Eg. 1.2.2018 4.3.2018 3.2.2018 4.2.2018--> i need this cell highlighted the cut-off is seven days, so if its 3.10 and 10.10, the 10.10 dont need to be highlighted

I am trying to form and array function and every time I highlight the function and do the hot keys i get #value. sheet 3

I need a formula or a macro that will look for the round up to the nearest integer version of the number in cell D3 (without actually changing the number itself), find another cell in column B (which are all formula output and not pure values that were entered in manually) that contains that number, and highlight the row of the cell found as well as insert "Tag 1" into the D cell of the cell found and mark E3 "FOUND" if found and "NOT FOUND" if not found.

I need a formula to highlight A6 green after I entered 'x' into either A11 or A12 Also I need a formula to highlight A15 Green after I entered 'x' into either A13 or A14

I want to be able to highlight a name on a master list and change the color then have all other cells with that name also have its color changed.

I need a formula for conditional formatting that will highlight when an agent name in column E and a box number in column F matches with an agent name and the same box number in column G. I'm showing a box was checked out to an agent with that number and then when the same number shows up in the checked in column, the two numbers and agent name should highlight.

I have a calendar and a list next to it with jobs and start & end dates. Ideally I would like that line (job, start, and end) to be highlighted a color and when I enter a start and end date have that range highlight the same color. How do I do this

I am working in an attendance tracking spreadsheet and I need to create a formula that will calculate someone's points based on their date of hire which is in another cell(and it has a conditional format that will highlight the cell if the person has been with the company less than 2 years. If they have been hired less than 2 years, attendance is calculated one way and over two years a different way. I can't seem to get the formula to work.