if/then changing text format to Bold

here is what i want to do

if a3 is = to 1 than change the text format in b4 to bold
if not change the text format to red

can this be done??

thanks in advance .. and thanks for all the help so far.

"cheshire191" wrote:

> here is what i want to do
>
> if a3 is = to 1 than change the text format in b4 to bold
> if not change the text format to red
>
> can this be done??



never mind ...i answered my own question

CONDITIONAL FORMATTING

thanks
>
> thanks in advance .. and thanks for all the help so far.