Dynamic conditional formatting

I have two columns. The first contains a status number and is conditionally formatted by color. The second column has a nested if statement saying if the column 1 cell is 1 column 2 is "New", if column 1 is 3, column 2 is "Active", etc. How do I get column 2 to have the same formatting color as column 1? This needs to by dynamic so that the color in both columns changes when the number in column 1 changes.

To put it another way, the format in the column 2 cells should be the same as that in column 1, dynamically.

Thank you.
I am using Version 1908 build 11929.203.

When I go to a New Formatting Rule and set the style to "Data Bar", there is no field to enter which range has values that determine the color, and which fields are getting colored.
In the attached image, column F is conditionally formatted, I want column G to have the same formatting.
Picture1.png

The equation in column G is...=IF(F3=1,"New",IF(F3=2,"Planing",IF(F3=3,"Active",IF(F3=4,"Complete","On Hold"))))
I have tried several "Format Style" options. The "Red, Yellow, Green Color scale is my preference.

It would help if you attached a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

I don't see "Go Advanced". I do see "Manage Attachments" and attached the file there.

See attached file.

I have applied 3 separate CF conditions to the range $B$3:$C$19 using the following formulae:

=$B3=3 ……. > Fill colour RED

=$B3=2 …….. > Fill colour AMBER

=$B3=1 ……… > Fill colour GREEN

Hope this helps.

Pete

Thanks. I can do that.

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Ok. Will do.