Select A15, do format>conditional formatting, select formula is from
condition1 dropdown and put

=$K$15="no"

in the formula is box
click the format button and select red and bold fonts and click OK twice

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Susan Renee" <littlemissie@discussions.microsoft.com> wrote in message
news:27DC0A68-3EB3-44EF-8CC6-ADFEA4EB9076@microsoft.com...
>I am trying to make the result of a cell Red and Bold if the cell result of
>a
> formula is past due.
>
> For example: I have a cell(A15) that is a client name. In cell #K15, the
> cells say either Yes or No.
>
> I want the client name to be Red in cell #A15 if the cell #K15 is no.
>
> Can anyone help?
> --
> Thanks for your help.