Mirror conditional cell formatting

[Tass]

Hi,

I have the following issue:
A22:A44 contains names (Alphanumeric)
B22:B44 contains corresponding values (numeric)

The values have been conditionally formatted which separates them into several groups (<-30, -30 to -10, -10 to -1, -1 to 1 etc).

I would like the names in Column A to appear in the same formatting that the values in Column B take on. Is there a way?

Thanks a lot for your time.
Here an example, with what I have, and what I would like to have (manually formatted, which does not suit the purpose, because it is not dynamic).
Example.ods (15.6 KB)

[schiavinatto]

Change the validation area by including column A and in the validation formula, set the reference to column $B.

Post an example of not being able to.

[Tass]

That was the first thing I tried. But that does not work because column A does not fit the validation criteria, being alphanumeric. I added an example to the main post.

[JohnSUN]

Use a different condition

Example2.ods (17.2 KB)

[Tass]

Oh gosh, so simple! Thank you. I was just thinking far too complicated. I tried a nested IF formula along the lines of =if(B2<-30,Style(Bad),if(… But that did not yield anything. Never thought about just breaking it up in many short formulae. Sometimes easy is the hardest.

Thanks John, much appreciated.