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