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

[Susan Renee]

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?

 

[Peo Sjoblom]

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]

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.

 

[edcosoft]

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

 

[Peo Sjoblom]

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