Just use conditional formatting (FormatConditional Formatting) and set the
font colour to red if the cell value is Fail Msg, Blue if Pass Msg.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MOHA" wrote in message
...
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.