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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

How can i highlight expired dates of certificates in an excel spreadsheet
Solved by C. C. in 29 mins
Hi there, I have pasted some rows from one document to another. These new pasted seem separate to the rest of the document i.e. when i highlight a column, it will only highlight the old part of the column and not the new pasted rows, also if i try to filter or format a full column it will lonely format or filter the old part of the document, the part before i pasted data. i can highlight the pasted rows and data separately but not all as one
Solved by C. B. in 30 mins
Hi, I am trying to combine 2 AND formulas so that I can sa if an error. I need to be in this example to highlight one of two things:- If the box "Y" for sign up, and there is a value in A2, text saying no error If the box is "N", and there is no value in A2, text saying no error Anything else (i.e ticked yes but no data before, or ticked no but data before), text saying error
Solved by K. J. in 26 mins
I want to highlight one part of data on a bar chart and the chart is picking up 2 bits of data
Solved by I. J. in 20 mins
Two Sheets: UTI List and Sheet 1 The VLE location in the UTI list mentions in detail the entire addresses with the district names.. all in a single text box. The Sheet 1 mentions all districts to take as reference I want to: 1)In the VLE Location column, extract the districts into a new column next to the address, if the district names mentioned inside the boxes, match exactly with any district in Sheet 1. 2) Highlight cells that dont match in red If possible; the cells with text that match closely with the districts, highlights in yellow
Solved by K. U. in 15 mins
How do I highlight a whole spreadsheet and ask it to Round up
Solved by G. L. in 29 mins
Hello I am trying to compare two tables on the same excel sheet. Following is what i am trying to achieve. This has to be done in excel VBA. TASK 1 If A matches F (Equipment numbers match) AND If B matches G (ID-Numbers match) AND If column C=1 (Equipment is in Service. C=0 means not in service) Then Update (copy/ paste) Column H with value in D (Update Inspection intervals from column D into H) But If A doesn’t match F (Equipment numbers DO NOT match) AND/ OR If B doesn’t match G (ID-Numbers DO NOT match) Highlight the cell in column A TASK 2 If A matches F (Equipment numbers match) AND If B matches G (ID-Numbers match) AND If C=1 (Equipment is in Service. C=0 means not in service) AND If Column I (Inspection Due date) has a red OR Pink Cell highlighted Then Update Column J with E (Update Inspection date (J) with Last Inspection date (E))
Solved by O. S. in 13 mins
how to highlight a row in excel? I want to highlight every row that contains the word uber in my spreadsheet
Solved by O. F. in 14 mins
i need to highlight the duplicated names from Column D (Unsubscribe) in Column C (Full Name)
Solved by V. Y. in 30 mins
I have an excel sheet of phone numbers. It is a large data 1) I want to delete all special characters,alphabet and space in the cells 2) After this operation, Highlight the cells that are not 10 digit
Solved by O. F. in 23 mins