In a test procedure, I end up with a column where I use CountIf to determine
if there are any F (for Fail) characters in the column [=If((CountIf(M25:M95,
"F")=0
("Pass Msg","Fail Msg")). This works OK.
I would like to be able to print the message in red font if it fails, and
blue font if it passes.
I have created a macro that will change the font color, and I can write VBA
code to do it. I have not figured out how to get the macro or the VBA Code to
run automatically following the pass/fail test.
Can it be done?
Security level set at Mediun, I have created a self signed certificate.