# 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

Hi there need some help with conditional formatting please, using =AND(LEFT(K\$4,4)="1350",K9>K34,K5<>"Buy") trying to make the cell not highlight red if buy is in row 5 but not working
Solved by O. B. in 20 mins
I'm using this formula to highlight cells in excel on the google sheets, but I can't get the formula to work for different amounts: =(LEN(E2)-LEN(SUBSTITUTE(E2,",",""))>2)
Solved by I. S. in 25 mins
Hi there I want some help with conditional formatting. Basically the spreadsheet shows values/spread changes of bonds over time. In columns Z-AT I have calculated the various curves. I want to highlight with a darker green colour where the current curve (is column z the current 3s/5s curve) is less than the mom and ytd and use red for when its less then just to show how curves have moved to give us ideas in from a name specific basis if it makes sense to sell the longer dated and buy the shorter dated.
Solved by K. Y. in 21 mins
I have a problem that I need help with. I am trying to use conditional formatting with multiple conditions to highlight one cell against another cell using greater than, equal to, and less than. The cell I want highlighted gets its value using a formula that gathers data from multiple areas in the spreadsheet. This seems to be the cause of my trouble. The cell I want to compare it to is a static number. For some reason no matter what I do I cannot get the cell containing the formula to highlight correctly. Ive tried all variations of =g3<>h3 but for some reason it will not work. (G3 is the cell that has a value obtained from a formula) What I am looking for is when G3 is less than H3 then G3 gets highlighted red. When G3 is greater than H3 then G3 gets highlighted green. When they are equal G3 stays white. PLEASE HELP! I've spent 3 hours on this already.
Solved by G. L. in 25 mins
I have a tabbed spreadsheet. Both have sku numbers and quantities. I want to highlight what skus are listing in walmart but not in amazon? So what skus are missing in the Amazon tab?
Solved by D. H. in 18 mins
I would like to highlight an entry that does not appear elsewhere
Solved by S. J. in 24 mins
How to highlight a column in excel? I am unable to highlight duplicate values from two columns.
Solved by M. Y. in 30 mins
Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task. Thanks :)
Solved by K. B. in 26 mins
Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task. Thanks :) Can you just guide me in the direction I need to go? Or explain how I would go about it and I can go play around with it? I don't mind if it takes longer than 20 min
Solved by O. F. in 24 mins
Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task when I click a button. I know how to do the drop down lists and make the button, I just need the macro that would do the rest. Is there already a general one out there that I could look at and tweak to fit my needs? Thanks :)
Solved by K. H. in 22 mins