Need formula to automatically bold rows of data

[Dwayne]

Is it possible to write a formula that will automatically
bold an entire row based upon information in that row?

 

[Dave R.]

Yes- but the bolding is not done within the formula, the formula result sets
off "conditional formatting" available from the Format menu.
e.g. if you want to bold A1:G1 if A1="Oregon"

then select A1:G1, go to format>conditional formatting, use "formula is" and
enter =$A$1="Oregon"
then select format, and choose bold/color/whatever.

 

[Gord Dibben]

Dwayne

Select a row.

Format>Conditional Formatting>Formula is: =$A$1="Monday"

Hit Format button and Font Tab. Select Bold and OK your way out.

Note the absolute reference at $A$1(or whatever cell you choose)

Gord Dibben Excel MVP