Auto default for cells

Occasional Visitor

I'm making a schedule and want OFF to be all caps and bold. How do I set this up?

1 Reply
You could use conditional formatting. Select the range you want the formatting applied. Then, from the home tab, click conditional formatting, select use a formula to determine which cells to format. Formula: A1="off" (but A1 should be the cell address of the top left cell of your range). Click format, number tab, custom and input this in the "type" box: ;;;"OFF" Then, go to the font tab and select bold.