Convert background color to a particular value

Have you taken a look at this tutorial? Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.

Here is some sample code from it that should help. It will output the color of a cell in the next column to the right of the selected cell/column.

Sub ListColors()

For Each c In Selection 

    c.Offset(0, 1).Value = c.Interior.Color 

Next c 

End Sub

Steps to change the background color

Start with selecting the cells the background color of which you want to change.

Create a new formatting rule by clicking Conditional Formatting > New Rule… on the Home tab.

In the "New Formatting Rule" dialog window that opens, choose the option "Use a formula to determine which cells to format" and enter the following formula in the "Format values where this formula is true" field: =$C2>4

Instead of C2, you enter a cell that contains the value you want to check in your table and put the number you need instead of 4. And naturally, you can use the less (<) or equality (=) sign so that your formulas will read =$C2<4 and =$C2=4, respectively.

Also, pay attention to the dollar sign $ before the cell's address, you need to use it to keep the column letter the same when the formula gets copied across the row. Actually, it is what does the trick and applies formatting to the whole row based on a value in a given cell.

Click the "Format…" button and switch to Fill tab to choose the background color. If the default colors do not suffice, click the "More Colors…" button to pick the one to your liking, and then click OK twice.

You can also use any other formatting options, such as the font color or cells border on the other tabs of the Format Cells dialog.

The preview of your formatting rule

If this is how you wanted it and you are happy with the color, click OK to see your new formatting in effect.

Now, if the value in the Qty. the column is greater than 4, the entire rows in your Excel table will turn blue.

As you can see, changing the row's color based on a number in a single cell is pretty easy in Excel. Further on, you will find more formula examples and a couple of tips for more complex scenarios.

Regards,

Rick Bale

1. Select the cells you want to format. You can select one column, several columns, or the entire table if you want to apply your conditional format to rows.
2. On the Home tab, in the Styles group, click Conditional formatting > New Rule
3. In the New Formatting Rule window, select Use a formula to determine which cells to format.
4. Enter the formula in the corresponding box.
5. Click the Format… button to choose your custom format.
6. Switch between the Font, Border, and Fill tabs and play with different options such as font style, pattern color, and fill effects to set up the format that works best for you. If the standard palette does not suffice, click More colors… and choose any RGB or HSL color to your liking.
7. When done, click the OK button.

Let me know if this works.

Regards,
Jerry M.