Make the result of a formula red (cannot be done in cond. format.)

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.

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.

How do I copy that down a row of cells.

For example, If K12=No, then I want A12 to be red, bold.
If K13=No, then I want A13 to be red, bold.
and so forth.

--
Thanks for your help.


"Peo Sjoblom" wrote:

> 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.
>
>
>

Select the whole range that you want to format, assume it is A10:A50, with
A10 as the active cell (if you select a range starting from A10 it will be
the active cell), then use

=$K10="no"

note the difference, no dollar sign before the row number so not $K$10 but
$K10
the repeat the steps I told you earlier

or change the formula is in A15 to =$K15="no"

then select A15, double click the paint brush and then "paint" the cells in
A that you want to format

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Susan Renee" <littlemissie@discussions.microsoft.com> wrote in message
news:E8D639E8-FD2B-4DAF-88AB-ED20EB494D0D@microsoft.com...
> How do I copy that down a row of cells.
>
> For example, If K12=No, then I want A12 to be red, bold.
> If K13=No, then I want A13 to be red, bold.
> and so forth.
>
> --
> Thanks for your help.
>
>
> "Peo Sjoblom" wrote:
>
>> 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.
>>
>>
>>

Instead of $K$15 in cell A15 put $K15 in cell A15. Then copy / paste
A15 down through A? as far as you want. ed