Get instant live expert help on I need help with excel get cell color value
“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
Help me to color excel row by value of a cell
Solved by B. B. in 15 mins
I want to give a cell in sheet2 the same color as the corresponding cell in sheet1. The cell in sheet1 is conditionally formatted (if the value is over 9,5 the cell color is red) . The cell in sheet2 must have the same color as the cell in sheet 1, no matter what the value in the cell in sheet 2 is.
Solved by V. J. in 15 mins
Let the user specify a range to apply conditional formatting . Overflow all cells in the range and apply the following formatting: a. Cell value <0: Comic Sans MS font, size 18, underlined, red font color b. Cell value tss 0 and 500: Bold, italic and underlined c. Cell value tss 501 and 1000: Font Monotype Corsiva, double underlined, blue letter color d. Cell value> 1000: Font Arial, bold, italic, background cell green, white font color
Solved by E. J. in 28 mins
I would like to assign a value to a cell based on a color; in this case it would be green. if a cell is green, I would like to have a value of 1. Then, I could sum all the green cells to get a total.
Solved by K. Q. in 20 mins
How do I copy and paste a color shaded cell and value
Solved by S. J. in 30 mins