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.

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

Select A15, do formatconditional 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" wrote in message
...
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.

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

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 formatconditional 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" wrote in message
...
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.

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

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

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

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" wrote in message
...
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 formatconditional 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" wrote in message
...
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.