Conditional Formatting Based On Another column in Excel google sheets

In Excel or Google sheets, it is relatively easy to apply conditional formatting based on the current value of a cell. However, suppose you run into a problem where you have to highlight or format a column based on the value of another column. You can use conditional formatting based on another column to solve such problems.

#########
#########

[northwestrepair]

I dont understand how this works but it works.
Thanks !