Color-format a cell which contains data in a column based on the color of another cell

Hello Excel experts, I am a macro newbie, but I want to learn (but this time I do not have the time for that) so I turn to your wisdom instead and hope for the best

My problem is:

I have a column C which is conditionally formatted where there is text and also a color (blue) for some specific text content, otherwise the color is unformatted.

Now I want the column to the left (B) which also contains data (numbers) to have the same color as the cell in the C column. (If one cell in column C is blue, then I want the cell in the B column to also be blue).

How would I go about doing this?

Thank you for your help in advance

you should be able to set the conditional format to be applied to both columns based on the content of one column

at the moment you select the column c and apply the rules for the format

lets say in the example

C1="blue left" and format to blue and now apply to C1:C50

to apply to the B column
change the C1="blue left" to $c1="blue text"
and apply to
B1:C50

see attached

this way column B is still looking at column C because of the $ sign

Thank you! That is a good piece of advice. Now where it says "blue left", in reality it says "blue left XYZ", "blue left ZOG", "blue left AOZ" i.e. different things after the first words. When I try to format "only cells that contain" and "specific text" and "Containing", I do not get it to work...? I feel really silly.

Hopefully this should be easily sorted out?

Edit: I solved it, thank you again!

you welcome

just in case you have an issue
you could use

left(C1,9)="blue left"