Use conditional formatting to highlight information
First select the cell or range you want to format.
In your case Cell B
Path Home -> Conditional Formatting -> New Rule -> Use formula to determine formatting cells.
Format values for which this formula is true:
=$C$3="No" Format or fill in the cell according to the color you want.
=$C$3="Status" Format or fill in the cell according to the color you want.
See simple example in file
Hope I could help you with these information / links.
I know I don't know anything (Socrates)