Select the range of cells where you want the formatting done, say A1:A10 in
this example. Formatconditional formattingformula is
=ISNUMBER(SEARCH("ZONE",A1))

If you want to find only upper case ZONE, change SEARCH above to FIND.

The formula in the cell itself would be =Sheet1!A1 (i.e., what brings "zone"
over or not).



"Abi" wrote in message
...
#1. Can I bold part of a cell that contains a formula? The cell is text,
formula, text, and I need the information that is returned by the formula
bolded, if possible.

#2. I have a cell on a sheet that merely pulls info from a second sheet -
no calculations or anything fancy, just:

Sheet2, Cell B1 has the formula ='sheet1'!A1

What I'd like to do is make a conditional format for this cell, but I'm
not
sure how to do it with the conditional formatting tool.

In plain english, I want the formula to say:

"Bring the information over from sheet1, A1. If, in any of the
information
hat is brought over, it contains the word ZONE, bold this entire cell. If
it
does not contain the word ZONE, treat it normally.

Can I do this? thanks!