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!

 

[Simon Lloyd]

Conditional formatting will either change the colour of a cell or th
font or both but will not produce text, you can simply use VLookUp t
find a value in a range, can you explain more on what text you have/ar
trying to get, i.e from where...etc

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

Thanks in advanced

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Barb Reinhardt]

Conditional formatting is on the HOME tab of Excel 2007.