Hello All,

I am trying to keep track of peoples' email addresses that are not receiving
my messages. Currently, the cell range A1:L1 contains my headings, Cells
A2:A126 contain the Contact ID numbers. Currently I have 126 Contacts. Column
K is my status Column. I want to create aconditional format that will format
the entire row as follows:
__________________________________________________ __________________
If K1="n" (n meaning not functioning properl.)
then formatting of A2:K2 should be font= bold and fill= red
else
If K1="f" (f meaning funtioning properly)
then formatting of A2:K2 should be font= bold and fill= bright green
__________________________________________________ __________________
Once I have the proper formula do do this I should be able to copy the
formula into each row.
There is one other problem though. Column L contains a Description of the
problem the email account is experiencing. Therefore I have already tried to
set up a conditional format so that if the value in K2="n" the formatting for
L2 would be font color=red. However, it wouldn't work. So how do I get L2
formatted so that the font type will be Arial and so that the font color will
be red without changing the result of the conditional formatting for the cell
range of A2:K2?

Any suggestions would be greatly appreciated.

Thank you,

John R. L.