Is it possible to set the color of a cell based upon a hex string (e.g., "RRGGBB") or a numeric value and if so how? I have a sheet that converts colors that are stored in BGR format to RGB. I would like would to set the cell color next to the converted RGB value.
Excel: setting the color of a cell based upon a value
microsoft excel
Related Solutions
You can mimic this in Excel 2007/2010 by using a formatting rule over the range in question:
- Two-color scale
- Minimum of type number with value 0 and color black (or white, your choice)
- Maximum of type number with value 255 and color red
Conditional formatting in Excel 2007 (based on value of another cell)
Select the cell you want to format, “A1″ in this example.
In the Home tab, Styles group, click on Conditional Formatting.
Select New Rule.
The New Formatting Rule window will open.
Click Use a formula to determine which cells to format.
The New Formatting Rule window will now look like this:
In the edit box labeled “Format values where this formula is true“, enter “=” followed by a formula referencing the other cell. In this example the formula: “=B1<0″ is entered.
Click the Format button. The Format Cells window will open.
Specify the formatting you want. In this example I changed the cell color to “RED”.
Click OK to close The Format Cells window.
Click OK to close The New Formatting Rule window.
To summarize this example: cell A1 will have a RED color when cell B1 value is less than zero.
Best Answer
You have to use VBA to accomplish your goal. Feel free to modify the routine below, which colors the background of the current cell, according to your needs.