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 know this will take more than 20 min. Can someone help me for 20 min with it and then I can come back later or keep working on it on my own? I'm 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 A. U. in 26 mins
My report has a formula that changes text in "L" column based on the date (column "K" being greater than 300 days. I want to highlight and change column "L" text if date in column "K" is greater than 30 days past date. I'm not sure if this can even be done in conditional formatting or if it will work better in VBA, Any help would be WONDERFUL! Thank you!
Solved by Z. B. in 28 mins
I was working with an expert but, I lost internet. I would like to copy the rows with "Deleted", "Inactive", or "Cancelled" to sheet2 and highlight them in grey.
Solved by T. E. in 12 mins
I was working with an expert but, I lost internet. I would like locate "Deleted", "Inactive", or "Cancelled" in the "Current Status" column. Highlight the row in grey and copy to sheet2.
Solved by I. W. in 11 mins
I would like locate "Deleted", "Inactive", or "Cancelled" in the "Current Status" column. Highlight the rows in grey and copy those highlighted rows to sheet2.
Solved by C. E. in 30 mins
I have four drop downs that highlight a range of cells in a single there a way to make a macro that will take that same information being used to highlight the cells and use it to select the cells?
Solved by Z. C. in 18 mins
I have a protected Excel worksheet, and I need to unprotect a few particular cells, but keep everything else protected. When I highlight the cells I want to unlock, the Format Cells option is greyed out so I can't select it. Please advise, thank you!
Solved by V. H. in 28 mins
From values in sheet 1 highlight any potential matches with their corresponding colors in sheet 2, either column A or column B
Solved by Z. A. in 22 mins
Say I have 2 columns - Column A has numbers 1-100 and Column B has ONLY the numbers 5,19, and 79. How would I highlight the Column A numbers that are NOT in Column B?
Solved by B. C. in 21 mins
I'm trying to use conditional formatting to highlight a cell in an array several columns before when the line goes less than zero. I can do this using conditional formatting by using the formula =O10<0 if I know O is the column that is in the correct position (i.e. 6 columns from the starting cell) However, if I need to calculate the column to start at, I am using =INDIRECT(H10)<0 where H10 has the starting column. This does not seem to work. Help....
Solved by G. B. in 18 mins