#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!