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

hi i need a rule for finding if the room column is the same highlight the whole row if start and end time are duplicated

I need to cross reference two sheets and find commons part numbers. When found, need to highlight them or hide the ones not found.

Hello. I have a table with numbers from 1-100. I want to highlight the multiples 7 for instance.. I am able to use the conditional format for one cell ie if =mod($A$1,7)=0 the fill with a color eg yellow. I am not able to use the format painter to copy this to the whole table in a meaningful way. So I would like the painted format in A5 to be =mod($A$5,7)=0 so the effect of the formatting is due to its own value not of the cell it was copied from ie mod($A$1,7)=0. I could do each cell individually, but that would be cumbersome. I assume there is a better way. Thanks in advance. Alok .

Need a single cells to highlight, if a range of cells is less than or equal to today, and also if equal to a certain number. Have managed to get the first line in the table to follow the rule but need it to apply to all of columns E & G without having to create the formula for each line of the table. Current formula: =AND(G17-TODAY()<=0,E17=1) which applies to cells C2:C5

To update existing Excel VBA to include to select any highlighted cells in several columns, recalculate the corresponding cell in another column, highlight that cell and move that column and the corresponding cell with the highlight over to the audit history columns.

How to highlight, in colour, part of a text in a cell

I have a one sheet, where there are 5 columns of responsible person names but those have only one name associated. Responsible1 Responsible2 Responsible3 Responsible4 App1 Person A App2 Person B App3 Person C App4 When we do conditonal formating, It has to highlight with "App4". Can it highlight empty row like "App4 " Need your support.

We have a lottery bingo sheet where each entrant picks 6 numbers and when they come out in the lottery they get highlighted in grey. At the moment I am having to go through each individual line/cell to highlight manually. I would like to create a formula/macro/vba to automatically highlight a cell if the value in it is in the range of data where I put the lottery numbers. I have had it done for me in the past but it was by a customer who no longer comes in to the pub, but 'm sure he used a macro/vba. Cheers

I need to do a conditional format highlighting in Microsoft Excel. G2 to G11 is dollar amounts. I need to highlight them if they are 5% greater than the dollar amount in J1. I tried "=G2>J1+(J1*0.05)" However, it is highlighting cells that are not 5% greater. Please help.

I need a rule that when the date in column F is today it turns the row light blue - if the date in column F is past today then it turns the row light red - once a date is input into column H then it removes the highlight if applied.