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

I have a worksheet (WORKSHEET 1) with over 1,000 static serial numbers. On a another worksheet (WORKSHEET 2) I have approximately 100 different cells where serial numbers are entered. I want to create a formula within the cells on WORKSHEET 2 that will check against the 1,000 serial numbers in WORKSHEET 1. If any of the static serial numbers from WORKSHEET 1 are entered into any of the cells in WORKSHEET 2 then I would like the cell to highlight, display a message, etc... to alert the person entering the data to stop and flag the serial number and move on.

If column F = today and there is no data entry in column H then I would like that row from A thru J highlight light blue If there is data in column A and column F = past todays date(past due) and there is no data entry in column H then I would like that row from A thru J highlighted light red

I would like to highlight a cell if it is greater than another SPECIFIC CELL i.e. When Cell A1 is greater than B1 I would like to highlight it. The Cell A1 (Tonnage Used) will be updated manually on a daily basis and I would like to highlight when its value has been reached or passed. e.g. Cell B1 has a constant value of 100 (Tonnage Required) Cell A1 will be accumulating on a daily basis up to OR passed 100 (Tonnage Accumulated on a Daily Basis) Cell A1 needs to highlight when achieved or passing Cell B1.

I am using excel to highlight duplicates and order research papers for a systematic review. My initial search had roughly 300 papers. I have done a new search which includes 400 or so papers. (each paper has various columns, such as Title, authors, abstract) etc. In theory my new search should include all 300 papers from the initial search (which I have already assessed). I match these old ("already assessed") papers to the new ones to (a) highlight new papers I must assess and (b) ensure that I am not missing any papers

In the % of Budget Spend create a formula to make a percentage =Committed/Pening/Annual T&M Budget Change the format from number to Percentage Highlight the data in GBS with Red background

I need help creating a formula that will highlight the column once the departure is passed in STEP1

hi i want to do formatting the cell based on formuls eg) column B is greater than column A, then column B should highlight in red color

I have 2 excel sheets, one contains an ID and an associated inventory for various types of parking spaces. The second contains the same ID, but has the raw data collected for the various types of parking spaces. I want to highlight any of the raw data entries that exceed the inventory on the first sheet.

I'm trying to have a A2:D2 highlight if D2 is blank. And then apply this rule to A3:D3 if D3 is blank and so on without having to individually type this rule for every row I want to apply the rule to.

I need to find like part numbers in columns A and O. Once found, I then need to highlight the column red if column i is less than column P. If column i is equal to or greater than column P, I need it to highlight green.