A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Select C1:C700. C1 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$B1
Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.