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

I want to conditionally format cells on a spreadsheet based on date. Using two side by side columns, I want to highlight cells in one column that have a date one year or greater than the adjacent cell in the column. In other words, Highlight this cell if the date contained in the cell is one year or greater than the date in the other cell, with each cell having it's own unique reference date from the another column.
Solved by E. L. in 27 mins
I need a conditional formula across 2 sheets that allows me to highlight items from one column on sheet 2 that appear on a column in sheet 1.
Solved by A. L. in 25 mins
IS there a way to highlight using excel conditional formatting entire row off of a formula instead of just a cell?
Solved by Z. H. in 29 mins
"There's a problem with this formula" MS Help says, "Start by clicking OK or press ESC to close the error message. You'll return to the cell with the broken formula, which will be in edit mode, and Excel will highlight the spot where it’s having a problem. " Well, Excel ISN'T doing that
Solved by B. B. in 20 mins
I need to use conditional formatting to highlight names that are displayed more then 2 times
Solved by M. Q. in 17 mins
I need to modify a correct conditioning formatting formula, it is highlighting the first and lat name however it need to also highlight the reoccurring names as well
Solved by E. E. in 28 mins
I need to create an excel conditional formatting formula if that cells in column K & L if they appear more then 4 times
Solved by F. L. in 14 mins
I am trying to highlight blank cells that are past a certain time using conditional highlighting excel.
Solved by T. H. in 11 mins
Please help me learn how to apply the conditional formatting in excel to highlight in red names of those billionaires who satisfy all of the following conditions: • Citizenship of Russia or United States • Age less than the average age of all billionaires on the list • Net worth more than $20bil.
Solved by E. B. in 18 mins
I want to make a Cell highlight red if no date has been entered in to it within 30 days of the date of another cell. How can I do that.
Solved by X. S. in 23 mins