Feeze
Path: VIEW--->Freeze Panes
Conditional Formatting
Path:Home--->Conditional Formattion
Function:One cell will be changed by another cell change happened.
demo:
B1 will change color to red when C1 choose No.
1.Select the B1 cell.
2.Conditional Formatting--->Highligths cells rules--->More Rules...--->Use a formula to determine which cells to format
3."Format values where this formula is true" type in =C1="No"
4.Click the Format button and and choose the red fill color .
Done!