How can I highlight a cell in a range, if its value is equal to a different cell?
Random numbers in range A5:A20.
I want to highlight a cell in this range if it is equal to B4.
[ A ][ B ][ C ] [ 3 ] [ 4 ] 24 [ 5 ] 20 [ 6 ] 24 [ 7 ] 18
In this case I would want only cell A6 to highlight as it equals B4.
I feel like it should be easy, but can't get it to work.