Conditional Formatting from a separate range?

I am guessing this is simple, but I cannot seem to find a good example when trying to search.

See attached example.

Picture two columns. One of Blanks. One of numbers or values. I want say all the values in the second column to be grayed out as their actual value is added in the first column.

I think conditional formatting does this but I'm having a hard time achieving this.

Any help is greatly appreciated.

Thanks,
Matt

That works exactly as I described but I tried to make a more "dummy" format to show than the actual thing I'm trying to accomplish because I did not want to publically share that info.

If I PM you could you look and I can explain?

Here is a reasonably edited version of what I'm doing.

I put a text box with a note on there explaining.

Thank you so much for that. It did the trick. Helps a bunch.

I've taken my child's sports roster construction to the next level.

Matt