Auto default for cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1886318%22%20slang%3D%22en-US%22%3EAuto%20default%20for%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1886318%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20making%20a%20schedule%20and%20want%20OFF%20to%20be%20all%20caps%20and%20bold.%20How%20do%20I%20set%20this%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1886318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1886543%22%20slang%3D%22en-US%22%3ERE%3A%20Auto%20default%20for%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1886543%22%20slang%3D%22en-US%22%3EYou%20could%20use%20conditional%20formatting.%20Select%20the%20range%20you%20want%20the%20formatting%20applied.%20Then%2C%20from%20the%20home%20tab%2C%20click%20conditional%20formatting%2C%20select%20use%20a%20formula%20to%20determine%20which%20cells%20to%20format.%20Formula%3A%20A1%3D%22off%22%20(but%20A1%20should%20be%20the%20cell%20address%20of%20the%20top%20left%20cell%20of%20your%20range).%20Click%20format%2C%20number%20tab%2C%20custom%20and%20input%20this%20in%20the%20%22type%22%20box%3A%20%3B%3B%3B%22OFF%22%20Then%2C%20go%20to%20the%20font%20tab%20and%20select%20bold.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted
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.