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 a formula to highlight with color for different item
Solved by E. L. in 18 mins
I have coded a ChartGenerator Macro for a SmartArt Graph and would like to add a 4th level. Somehow the color keeps being the same as on the 3rd level - can you help? (The predefined SmartArt Graph has only 3 levels)
Solved by D. Y. in 14 mins
I need a formula that will allow me to conditionally format and color code a master calendar for as long as necessary. That would be about seven colors. I tried to do =$G="Governance" as a test - governance being my column G text that would turn the row brown, etc etc but it does not work. I would need a formula allowing me to duplicate this for several different column categories
Solved by O. Q. in 20 mins
I want a cell to be a color if it is blank but once someone types something in it, the color will go away
Solved by X. H. in 19 mins
all of my color coding was lost in my saved document. how do i retrieve it?
Solved by F. H. in 14 mins
Im using excel and it wont let me create a pivot table nor will it give me options to sort columns. it give me two options font and color. I need more sorting options like alphabetical order. or alphabetical 1st then numberal 2nd command. Ive never had this issue before using excel. usually the options are just available . Please advise?
Solved by K. S. in 20 mins
I need to figure out how to automatically color code a bubble chart
Solved by D. S. in 28 mins
I need to add an option to sort by cell color to the following macro. For Each Column On ActiveSheet.UsedRange.Columns Column.Sort Key1:=Column, Order1:=xlAscending, Header:=xlYes, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Next Column Need to add: SortOnCellColor, SortOnValueColor = RGB(255, 199, 206) in the above macro
Solved by E. Y. in 21 mins
I have an excel document that is printing in gray scale even though it is a color document. I am using a Xerox printer and the preview shows in gray scale and not in color. How can I fix this as I want it to print in color.
Solved by V. U. in 17 mins
I want to show 3 bars in a chart, lets say Academics, Production, and Learning Y-Axis should have Week Numbers, Like week-1 to week-12 Values are in dates. Now the the query is, if any cell value is missing, that part of the bar must change it's color for instance, the bar is green and missing part, that little chunk is red. No VBA please. Weeks in slicer is acceptable
Solved by M. U. in 27 mins