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!”
Here are some problems that our users have asked and received explanations on
How do I Auto change the color of a specific word on every cell that I type it in?
Solved by X. F. in 28 mins
Hi, I am creating a chart showing our revenue for the past 5 years. the 2018 column is YTD but I need to add what our projected revenue for all of 2018 will be. How do I add the projected info on top of the 2018 bar in a different color? Thank you!!
Solved by C. S. in 13 mins
I need to create a formula that gives a certain color based on numerical value chosen from a drop down box
Solved by T. S. in 19 mins
This file will not print showing the background colors, or any color. i have tried all options that I can find. This has started to happen with all files I am printing.
Solved by I. H. in 30 mins
I need a conditional formatting formula that highlights a selected row when a cell has any data in it. I have tried LEN($AF3)>" " What I need to track is when a value of $0.00 or greater is entered, it colors a row. If I use just plain zero, even if the cell is empty, it colors the row. I don't want it to color fill unless there is data in the one cell
Solved by T. S. in 14 mins
I want to apply color scales to column of text based upon the adjacent row. Then I would like to be able to return the color formatting in another worksheet based upon a match of Text.
Ex
WSH 3
DAL 2
ARI 1
I am looking to have these text values return their respective color on the scale in another worksheet
Solved by A. J. in 11 mins
I want to apply color scales to column of text based upon the adjacent row. Then I would like to be able to return the color formatting in another worksheet based upon a match of Text.
Ex
WSH 3
DAL 2
ARI 1
I am looking to return the color scale on QB PTS to Sheet ! based on the text WSH
Solved by I. L. in 30 mins
if i have criteria that needs to be met to create a specific color
if e2 is less than or equal to 70, green or if e2 is less than or equal to 90, blue or if e2 is greater than 90 but f2 is is less than equal to 110, blue, or if e2 is greater than 90 but f2 is is less than equal to 115, yellow, or if e2 is greater than 90 but f2 is is less than equal to 120, pink, or if e2 is greater than 90 and if f2 is greater than 120, red
Solved by K. H. in 24 mins
I need a formula to change cell color to green if value of its prevoius cell is smaller and change color to red if value is greater. And this formatting should be applied in continous cells
Solved by S. H. in 12 mins
I want a formula to look for a color cell and respond with the number in a different cell
Solved by I. E. in 15 mins