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
I have three columns with R,G,B numbers all <256. I want to translate the data into the background color of a 4th column
Solved by F. H. in 24 mins
Need to change the color of the cell based on the RGB code
Solved by X. J. in 16 mins
excel page showing in gray color page 1 on some pages but its not showin when printing page
Solved by G. J. in 16 mins
Please enter value "2" in column if name color is red
Solved by F. J. in 30 mins
color coding positive and negative numbers and titles for columns
Solved by G. H. in 13 mins
I need help on conditional formatting dates. So in short, I need the cells to be red if the date is between the 1st and 14th, then green if the date is between the 15th and 30th (or 31st). The current formula I am using is the following:
RED
=TODAY()>DATE(2017,8,1)
=TODAY()>DATE(2017,9,1)
=TODAY()>DATE(2017,10,1)
=TODAY()>DATE(2017,11,1)
=TODAY()>DATE(2017,12,1)
GREEN
=TODAY()>DATE(2017,8,15)
=TODAY()>DATE(2017,9,15)
=TODAY()>DATE(2017,10,15)
=TODAY()>DATE(2017,11,15)
=TODAY()>DATE(2017,12,15)
So, I went in to the "Conditional Formatting" then went to manage rules, add rule. Then I did it in order of month, red to green. For example I would copy and paste the 8/17 red code and then the 08/17 green code, in order up to December 2017. It is now the 20th and I opened the excel sheet to check if the cell would be green because the date range but it is not. I have an attachable image.
Solved by E. F. in 19 mins
customer has to by 4 cases of hair color and then they can choice 10 developers (mix and match) from two selection
Solved by M. F. in 28 mins
I am trying to use excel to come up with a flow plan for my students. I have 5 color stations (yellow, pink, purple, green, and blue). I don't want them following each other. i.e. The ones that start on blue, will be sent to random color stations. Some yellow. Some pink. etc. In the end, they will need to have done all 5 stations. So, one students might go blue, yellow, pink, purple, green. Another might be blue, purple, green, pink, yellow. Another yellow, green, purple, pink, blue. Do you know any rand function that will help me determine the various routes?
Solved by I. J. in 18 mins
I have a list of staff initials a two week timetable and two locations (e.g.Locations identified by cell color or text color) how can i count/sum which staff member has chosen which locations by putting colored text in a session.
Solved by F. A. in 25 mins
Hi I need to do a SUMIFS function with horizontal and Vertical. Yellow color highlighted area's in the attached excel sheet has to be the criteria;s which varies.
These should pick from the data sheet
Solved by V. E. in 29 mins