I have a column of names (L:L) to which I need a conditional format that highlights a specific name in the column.

The name is set by the value of another cell elsewhere (B3) in the sheet and changes frequently, hence the highlighted name in L:L will also change each time depending on what the value of B3.

I can't figure out how to reference the value of B3 in either Exact Text or Custom Formula.

CodePudding user response：

As already stated, the solution is to use the format rule Text is exactly and have your desired cell locked via an absolute reference: =$B$3. You can read more about formatting rules