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 have one weekly schedule page that transfers to a daily coverage chart page and i want the time range to auto fill with color indicator.
Solved by F. Y. in 20 mins
I am trying to use a simple Conditional formatting to highlight the row based on the data in column B. My formula is copied from several other online sources. I am actually using the same formula in another workbook, and its fine. I don't understand why this isn't working. =$B2="NA" is the formula. Chose a color for highlighting. Selection of my entire sheet - Nothing. It doesn't highlight. I have moved the formula and changed the data. Lost and Confused. please help.
Solved by D. B. in 14 mins
Need help with a school assignment. After choosing the more colors from the paint bucket, I cannot find the custom choice to find hex color.
Solved by A. L. in 15 mins
Have Excel 2011 version. Need to choose hex color and enter number. Cannot locate custom option when choosing more colors on paint bucket
Solved by T. S. in 27 mins
Hi This is Premkumar, I have been working as system Admin in one Transport Organization, we have more than 400 Trucks to export cement and other goods from Particular Position and 400 drivers working with us. So I need to enter the data of Driver details in Excel sheet including driving license expiry date. So my question is how will we put driving License is going to expire as automatically before 10 days or 15 days by Showing warning message like "The Driving License is going to expire for the Particular Driver". And It will be showing like "Red Color against Expiry Driving License. So Please give the Exact Solution for my Query. Thanks you
Solved by B. H. in 24 mins
i made a conditional formatting rule for one cell to change color if the value entered is the same as another cell. all cells where the origional cell is 0, the other cell has already changed color. how do I fix it?
Solved by D. B. in 22 mins
I need to color fill 1 cell based on if another cell is blank... example.. if cell p14 is blank, then f14 is filled yellow.. when p14 has a date in it, the yellow goes away... ???
Solved by G. J. in 13 mins
I need to create a formula that populates a calendar with a color based on certain tasks done on certain days. For example, a certain task might start on a Wednesday, and extends 6 days. I can create that formula, I just would like to exclude the weekend from the count, so in this example Wednesday, Thursday and Friday would be filled, and so would the first three days of the next week starting on Monday.
Solved by M. Q. in 26 mins
I AM FORMATTING A MASTER TEMPLATE IN ORDER TO UPLOAD EXPORTED INFORMATION. I HAVE SET UP A TEMPLATE THAT WILL ALLOW ME TO C&V AN EXPORTED DOC. COLOR CODE, ITEMS ARE NEEDING ATTENTION. NOW WHAT I WOULD LIKE TO ACCOMPLISH IS TO SORT THE ITEMS BASED ON COLOR BUT ONLY WITHIN THE LIST OF CELLS A. ALSO I NEED IT TO AUTO GENERATE A SECOND SPREADSHEET THAT WILL SHOW ME A TABLE FOR 2 THINGS. 1) HOW MANY OF EACH: ACCEPTED, DECLINED, INVITED AND INVITED/VIEWED WITH NO RESPONSE BUT NOT DOUBLE COUNTING ITEMS WITHIN THE SAME COLUMN A. NEXT I NEED A LIST OF COLUMN A'S GROUPS THAT DO NOT HAVE ANY "ACCEPTED" (GREEN) ITEMS.
Solved by S. Q. in 17 mins
Wanting to automatically generate a chart from sheet1 to sheet3 that sorts by group name AKA column 1 headings (EXAMPLE 1, EXAMPLE 2, EXTRA,) and organizes it by color green,blue,yellow, then red. *Notice* that color is based on Conditional Formatting tool and is order specific in order to give me the coloring scheme that is wanted. For now we will ignore sheet2. Thanks
Solved by B. B. in 21 mins