Excel – Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

colorsconditional formattingmicrosoft excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells – A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere between 0 and 255 of the number in the cell (so if it is 128, it should be like half red). For that given cell, the other values will just be 0, 0 (so in this case, zero green and zero blue).

Is this possible?

Best Answer

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

Related Solutions

Excel: setting the color of a cell based upon a value

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.

Sub ColorGrey()
    ActiveCell.Interior.Color = RGB(100, 100, 100)
End sub

Excel conditional formatting of row

You can count the number of occurrences of "A", "B" and "C" in each row using COUNTIF, and then add the results together. If any of those values are present in a row, the sum should return a non-zero value.

Try this:

Go to Conditional Formating > New Rule > Use a formula to determine which cells to format

Enter this formula:

=(COUNTIF($D2:$L2, "A")+COUNTIF($D2:$L2, "B")+COUNTIF($D2:$L2, "C"))>0

Set your format and click OK.
Make sure that the Applies to box in the Conditional Formatting Manager window is set to =$D2:$L2, or the row(s)/range(s) that you wish to apply the conditions to.

These should also work:

=COUNTIF($D2:$L2, "A")+COUNTIF($D2:$L2, "B")+COUNTIF($D2:$L2, "C")

=COUNTIF(2:2, "A")+COUNTIF(2:2, "B")+COUNTIF(2:2, "C")

Best Answer

Related Solutions

Excel: setting the color of a cell based upon a value

Excel conditional formatting of row

Related Question