Here are some problems that our users have asked and received explanations on
how to conditionally format cells with values above a certain level in a single, non-gradient color?
Solved by F. Y. in 22 mins
I have a column of numbers on one spread sheet, and another column of numbers on a second spread sheet. I need the cells, on the first table, to change color if the numbers match the numbers on the second table
Solved by D. D. in 17 mins
I need a formula in conditional formatting that will make a cell a certain color based on what table that value is being drawn from.
Solved by B. W. in 12 mins
Need a way to format Bar chart in different color if value is above 100 then green if 80-99 then yellow and below 80 should be red
Solved by M. S. in 23 mins
How does one change the color of font when I can't 'see' the font?
Solved by I. W. in 14 mins
I have what I hope is an easy problem to resolve.
I create spreadsheets with the format I require usually including fill color in some cells. When I open the file later all of the custom formatting has disappeared. The cells with color now have no color. The columns that I set at 20 ends up back to the default width. How can I ensure that these custom formats are retained?
Solved by M. J. in 14 mins
I have a multisheet workbook. I have a vlookup on one sheet that pulls in information from another sheet. The information I need to show has certain fonts and color based on the vlook up requirements. I can not get the font and color to pull. I have tried a VBA but it is not working.
Solved by Z. A. in 21 mins
I have every other row automatically alternate colors, however, when I hid a row, it does not automatically update the color change to show every other row. Is this possible?
Solved by T. J. in 26 mins
I have created a sheet to calculate the cost of hair based on several factors: the length, the color and the ounces. I need to enter the required information on the HP Calculator sheet in the EXT PLUS PP HAIR section. I need these values to pull dollar amounts from the Ext Plus sheet and fill in the appropriate value on the HP Calculator sheet. I am stuck on the color value. I can't perfect the calculation to evaluate which group the selected color is in.
Solved by I. Q. in 15 mins
is there a way To allow the editing of a cell based on another cells color