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 am trying to set up a tracking system for tracking recurring inspections on a helicopter. I want to color code these recurring inspections in a way that it is easy to visually identify the inspections that are lining up with other inspections
Solved by X. W. in 25 mins
I have a list of products and a list of colors available for those products. How do I create a list of products and color for each value. 10 products and 10 colors would generate a list of 100. each row containing product # in col a and color in col B.
Solved by T. Y. in 26 mins
The highlighter on the very left side to use "find" is too hard for me to see easily - could I make it a different color or bold? can you help with excel color based on value?
Solved by G. H. in 29 mins
In the very first left column in Excel - Row numbers. When I use "Find & Replace," can I change the color that highlights the row?
Solved by D. U. in 21 mins
I would like to get an excel formula to change cell color that will identify if there were a duplicate on the list and highlighted those in color.
Solved by K. B. in 30 mins
I need to color code column "d" based off several rules: if the date in column "c" is within 90 days of today it is one color, if it is 90>today>=120 it is color 2, if it is 120>today>=180 it is color 3, if it is 180>today>=210 it is color 4, if it is today>210 days it is color 5. I have gotten the formula to work, however I cannot get it to work for each date. I.E. d2 works based off c2 but i cannot get that rule to apply as d3 to c3 and so on. I have 800 lines and don't want to type out 5 rules 800 times
Solved by B. H. in 21 mins
i need column d to color code to column c based off today's date
Solved by V. B. in 19 mins
I need to make a graph (pie chart) showing the % of each color from the conditional formatting.
Solved by X. C. in 15 mins
I want to have macros recognize the color of cell, rather than the values, to be formatted a certain way.
Solved by K. H. in 25 mins
Column 1 has a locations(HA01-01-A1,HA01-01-A2.....etc) and column 1 is divided into four categories and in column 2 a specific color is filled beside different categories. In another worksheet layout locations of the warehouse(HA01-01-A2 etc..) are present.I wanted the corresponding colours to be filled in the locations according to the category.
Solved by M. D. in 25 mins