excel - Is it Possible to Color a Column/Row of Cells based on another Column/Row of Cells? -

There are two columns; The first four colored cells are, while the other numbers are there is any way to color the second column so that it corresponds to the colors of the first column in the same order.

Example A1 = Green, A2 = Red, A3 = Gray, A4 = Black (Color). B1 = 4, B2 = 3, B3 = 2, B4 = 1 (Blank).

= A1 = Green, A2 = red, A3 = Gray, A4 = black (color) = B1 = 4 (green), B2 = 3 (red), B3 = 2 (gray), b4 = 1 (black) (color).

Managing the column manually will not work here because I want to be able to match the cell next to a cell in the second column with the color that changes its color. For example, if a cell in column A changes from "black" to "red", then i want to change the same cell from column "black" to "red" in column B.

Example A1 = Green, A2 = Red, A3 = Gray, A4 = Red (Color) B1 = 4 (green), b2 = 3 (red), b3 = 2 (gray), b4 = 1 (black) (color)

A4 is now "red", while B4 is still "black". I want it so much that if A4 color changes, then B4 color will change and match A4.

I tried to experiment with conditional formatting, but it seems that the work is not being done till now, there will be a formula for something like this, or is I SOOL?

This is possible using conditional formatting.
You have to select both columns and then choose to use the formula for conditional formatting.

P> fixes the formula $ in the first column. If you leave it, then only Column A will be colored.

In this way you will have to type the color of the cell background in column A, and if you set the font color for the same value you will not see it ...

Another option would be to use a VBA macro, which runs on every sheet exchange event that will copy the background color from column A to column B

Edit: As stated, you have to make a rule for each color.