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 manually color coding a list in excel, however halfway through the page every-time i enter something it automatically fills in red which i dont want . I want to be able to put the information in and come back later and fill it the appropriate color. There are no formatting rules on the sheet but it does this every-time i fill a cell please help
Solved by X. F. in 30 mins
I have a macro which copy's the entire Sheet 2 to Sheet 1 based on the headers. But, I would like the code to consider the rows which are highlighted in a specific color. Example: Sheet 2 has multiple columns and Sheet 1 will have only 5 or 6 column with headers of Sheet2. With my script, Sheet 1 will pull the complete row; based on the headers from Sheet 2 (Ex: 10). Now, I need to modify the script a bit where it will pull only highlighted(in Red) Rows from Sheet 2 based on the headers(Ex: 2 rows).
Solved by E. Q. in 22 mins
I'm trying to change the background color of just a few cells. I've tried clicking onto the space with the correct color and copying to the other cell without any luck
Solved by F. Q. in 29 mins
Is it possible to color the region between two cells with the same value and have empty cells between eachother
Solved by V. Y. in 13 mins
Hey, I highlighted cells based on various data such as Walk Ins Using POS Non English Prefer Text NO POS/No Tech/Paper Corporations Bad Numbers Duplicates Messages These are all in different colors. Can I filter the info by color on my ALL DATA sheet?
Solved by D. H. in 16 mins
I'm designing a spreadsheet to track the daily status of over 40 personnel. I'd like to simplify the process by having the "calendar" portion of the spreadsheet have its cells populate with color based on the date range I enter at a section at the bottom. Is this possible? Currently I have to manually highlight the date range and select the appropriate color scheme.
Solved by T. W. in 15 mins
I'm trying to apply a rule connecting color change in a row (within the first two columns) to the text that's given in the first column. However, even though the range continues into the second column, the color change does not apply there.
Solved by K. U. in 28 mins
On the 3 green tabs "LTV Graphs" use countifs to fill in data in range table excluding zeros.Then create a stack bar graph in all three green tabs using that data, define the Y Axis as "LTV Range" and the X axis as Loan Quarters. Use similar color sequence as the graph in red tabs
Solved by Z. J. in 26 mins
is there a way how could I change the font color automatically depending on the number assigned? like if the number is 1 font color would be green then if 2 it would be red, if 3 it would be yellow.
Solved by M. S. in 26 mins
how can change the color of the font if the value are below 85% and green if 85% and above?
Solved by G. A. in 18 mins