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 am using excel V 16.10. I have a problem with a text box within the spreadsheet. 1. When I add words in the text box I can see the cursor moving as I type but I dont see the words. When I click outside the text box the words appear. 2.) Same thing happens when I erase contents of text box or when I highlight sections of the paragrahas. The rest of the spreadsheet works. The problem is only on this text box. Can you help me with the excel text function?
Solved by I. A. in 20 mins
I have created a gantt chart in Excel, that highlights the cells with a color, according to the amount of days an activity has. I use a Conditional Formatting (CF) formula on a group of cells (=OG(J$6>=$E7;J$6<$F7) ) for that. If the formula is true, then the cells change color. My problem is, that the calendar includes Saturdays and Sundays (weekends). How can I write a formula in CF that will jump the weekends and count the rest of the days on monday. Fx. An activity starts on a thursday and last 5 days, then it shall highlight T, F, M, T and W. In advance, thanks for the help.
Solved by T. B. in 19 mins
I have a excel sheet which I can use to track employee leaves and attendance, however where I work employees are required to work on the 1st, 3rd, and if applicable 5th Saturday in a month. 2nd & 4th Saturday are weekoffs. My sheet doesn't have option to highlight only 2nd & 2th Saturday as week offs and i need help with the existing IFERROR formula in the sheet.
Solved by T. U. in 20 mins
I want to be able to use conditional formatting to highlight a column of different values in comparison to another column, but all the values vary. I know how to use conditional formatting to highlight a value over or under a set amount but not a varied one?
Solved by E. E. in 18 mins
Conditional formatting, I have two columns A and B with 50 different rows. Each row could have the same data, or different data. If a value in column A is present in column B I want to highlight that cell grey, if a value in column B is not in column A then I want to highlight that cell white.
Solved by K. W. in 26 mins
Hi, I need something on excel to highlight any cell with numbers more then 2 decimal places.
Solved by V. D. in 27 mins
I need to take a look at two rows and find the same numbers and highlight them leaving the odd ones out, make sense?
Solved by S. Q. in 21 mins
Formulate a linear programming model for this problem. (20 points). List the objective function (minimize or maximize) and all model constraints. Solve problem using MS Excel’s Solver (20 points). Hint: Use the “integer” constraint Highlight the "winning" cells in Excel
Solved by B. U. in 17 mins
When I try to highlight a selection of cells to print, sometimes it moves the cells I highlight, and sometimes I do it right and actually do select the correct cells (so I can set the print area). How do I select a set of contiguous cells? Please help wtih highlight on excel
Solved by Z. J. in 24 mins
I am trying to do a SUMIF calculation and when I hit insert function and then chose SUMIF it brings up 3 things: range, criteria and sum_range. I can properly select the data I want in there (ex: E2:E6) but I want to make it and absolute cell reference and I am using a mac so I highlight it and click command t but a "ding" noise pops up and it doesn't allow me to change it. I am not sure why. I am following along with an excel module program and the instructor does it frequently and it works every time for him. I have attached a file, and the first sheet is empty and the second sheet has the formula I am supposed to put in.
Solved by I. J. in 27 mins