Here are some more detailed instructions on applying the formula DerbyDad03 suggested:
From the Menu select 'Format' and then 'Conditional Formatting...'
In the dialog box, from the Drop-down list under 'Condition 1' select 'Formula Is'
Enter the formula in the box to the right of 'Formula Is'
(You can use Ctrl V [Control Key and V pressed together] to paste a copied formula into the box)
Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and false.
Click the 'Format ...' button and select the appropriate Tab, e.g., Font or Patterns (for cell background), click OK
Click OK again (or 'Add>>' to add a further formula and format).