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 need some help, I have a range of data that I want to check if there is a duplicated Row and Highlight with a color, wonder how to do it using a macro
Solved by V. S. in 22 mins
I am doing an excel project for a class using stocks. I have used closing prices for each day and want to make each day green or red depending whether the stock had a gain or loss from day to day. How do I do this so that if a cell value is changed the color can change also?
Solved by S. F. in 16 mins
I am coding a tetris project using VBA and have figure out how to delete a row but I now do not know how to make the tetris blocks that were above that deleted row of blocks move down one cell block on the screen. The code for it is below: Sub SumBlocks(T1, T2, T3, T4, T5, T6, Total) 'Subprogram that adds the cell values of the blue blocks in a row. Total = T1 + T2 + T3 + T4 + T5 + T6 If Total = 6 Then 'If/Then statement that makes a completely filled blue cell block row the color of the game screen. Cells(i, j).Interior.Color = vbCyan Cells(i, j).Font.Color = vbCyan End If End Sub
Solved by B. S. in 22 mins
Hi, I want to add two number and compare in same cell Ex : A. xx B. xx C. 25 Add A+B and compare with C. If A+B is greater than C , i want to show in red color.
Solved by V. C. in 28 mins
I need a formula that shows: if D2 is 0-305 and D4 is 311-330, cell D4 will be a specific color.
Solved by C. H. in 29 mins
I want to know how to color every other row, like an accounting ledger.
Solved by O. W. in 24 mins
I am trying to create a formula that will add categories already set for the column. A value of 1-69 the box turns red in the column; a value of 70-79 the box turns orange, a value of 80-89 the box turns yellow, a value of 90-100 the box turns green. So at the bottom, I want to put a formula for each color that will total how many reds, oranges, yellows, and reds.
Solved by S. F. in 16 mins
How can I create an "If" statement to change the color of a cell by using a checkbox that is in another cell?
Solved by K. H. in 11 mins
when I do the conditional formatting on a dropdown, and I choose something from the drop down, the color change, which is correct, but when I select it again from the drop down, the color only change half the way
Solved by D. H. in 28 mins
I would like to create a conditional formatting so i can easily check if the buyer was already paid or not, i want to make it fill by a color everytime I type pd. Currently I am doing it manually.
Solved by O. C. in 21 mins