Need formula to automatically bold rows of data

  • Thread starter Thread starter Dwayne
  • Start date Start date
D

Dwayne

Is it possible to write a formula that will automatically
bold an entire row based upon information in that row?
 
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.
 
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
 
Back
Top