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.