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

Jon;528819 Wrote:
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

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145312