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

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 :)

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!

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.

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.

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.

I have four drop downs that highlight a range of cells in a single column...is 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?

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!

From values in sheet 1 highlight any potential matches with their corresponding colors in sheet 2, either column A or column B

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?

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....