Get instant live Excel expert help to learn how to color in excel cell

“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 trying to make a random exam generator using a database of numbers with corresponding book questions. The exams 12 questions long with questions being randomly assigned by their number from the database. I have generated exams using RANDBETWEEN and want to print the questions to the exams by their number ID and their color. For example, I have done EXAM 1 by hand. How do I do this en mass? Thanks.
Solved by B. F. in 14 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 file with numerous tabs of pivot tables. Recently, when I filter the table some cells will turn to black fill instead of keeping color formatting. How do I fix this?
Solved by F. J. in 30 mins
I need a formula that: a. draws multiple dates from a tab that contains rows of qualitative data b. inserts those dates in the appropriate rows and columns of another tab that is formatted as a calendar c. ideally, those dates will not appear as dates on the calendar tab, but instead as a letter conditioned by another column of the data tab. d. it would be great if we could color code the populated entries depending on the audience type (which is another column in the data tab.)
Solved by B. U. in 21 mins
Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices. Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation and set appropriate margins so that the data will print on one page.
Solved by O. W. in 26 mins
I input dates from last year and i want to color code them based on how close they are to experation
Solved by F. J. in 24 mins
i need to know about how to change by functionally cell color can anyone there guide me
Solved by V. B. in 16 mins
I want to add background color on a excel footer on a mac
Solved by I. Q. in 20 mins
1) Please help me enter an end date formula based on start date and duration. I have this set up but it's including weekends. 2) Is there a way to take this duration and fill in the Gantt chart timeline on the right? Would be great if we could reference the color for that phase of work. (e.g. design, development etc.) 3) Fix spelling in the "holliday" formula to have just one l, so it reads "holiday" unless it breaks everything. Much lower priority.
Solved by T. W. in 16 mins
I want help with excel formula to change cell color based on text. The goal is to create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column.
Solved by B. Y. in 21 mins