You are going to learn, how to format whole row not only one cell. It can be useful for some reports or presentations.
You have some sales report.
You can format rows, which sales is more then 10 000$. First select your data without headings.
Next go to the ribbon and click Conditional Formatting and New Rule.
On the dialog box choose Use a formula to determine which cells to format option.
Write down =$B5>$C$2 formula.
Next click Format and choose how your rows will be formatted. I clicked Fill and chose yellow background.
Click OK and see you data formatted? Isn't it easy?