Conditional Formatting in Excel 2007

[Jon]

Long time user of Excel 2003, new to Excel 2007. I'm trying to use
Conditional Formatting in Excel 2007. I'm using a drop down list in cell A1
to pick the text I want inputted in a cell. I want a cell B1 to "auto-fill"
or "auto-select" different text based on the input from cell A1. I cannot
find the Conditional Format option in Excel 2007.

Thanks in advanced!

 

[Barb Reinhardt]

Conditional formatting is on the HOME tab of Excel 2007.