Bolding with formulas and "if/thens"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

#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!
 
Select the range of cells where you want the formatting done, say A1:A10 in
this example. Format>conditional formatting>formula 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).
 
Thanks!

Dave R. said:
Select the range of cells where you want the formatting done, say A1:A10 in
this example. Format>conditional formatting>formula 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).
Click to expand...
 
Try this:
- Select cell B1 which contains the formula: ='sheet1'!A1
- Select Format-->Conditional Formatting. Click on the Drop down list just
below Condition 1 and select: Formula is
- In the field to the right type the formula: =NOT(ISERROR(FIND("zone",
B1,1))) and choose the desired formatting

The formula in the conditional format is looking for the string "zone" in
the cell B1. If it exists then there is no error returned (not(iserror))
and the condition is met and you get the desired formatting. Of course the
converse also applies.

If you want to copy this format to other cells, beware that B1 is relative
and you may need to fix a row or column with $ as desired.

HTH,
Alex
 
Back
Top