software

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 formatgt;conditional formatting, select formula is from
condition1 dropdown and put

=$K$15=quot;noquot;

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

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Susan Reneequot; gt; wrote in message
...
gt;I am trying to make the result of a cell Red and Bold if the cell result of
gt;a
gt; formula is past due.
gt;
gt; For example: I have a cell(A15) that is a client name. In cell #K15, the
gt; cells say either Yes or No.
gt;
gt; I want the client name to be Red in cell #A15 if the cell #K15 is no.
gt;
gt; Can anyone help?
gt; --
gt; 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.quot;Peo Sjoblomquot; wrote:

gt; Select A15, do formatgt;conditional formatting, select formula is from
gt; condition1 dropdown and put
gt;
gt; =$K$15=quot;noquot;
gt;
gt; in the formula is box
gt; click the format button and select red and bold fonts and click OK twice
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Susan Reneequot; gt; wrote in message
gt; ...
gt; gt;I am trying to make the result of a cell Red and Bold if the cell result of
gt; gt;a
gt; gt; formula is past due.
gt; gt;
gt; gt; For example: I have a cell(A15) that is a client name. In cell #K15, the
gt; gt; cells say either Yes or No.
gt; gt;
gt; gt; I want the client name to be Red in cell #A15 if the cell #K15 is no.
gt; gt;
gt; gt; Can anyone help?
gt; gt; --
gt; gt; Thanks for your help.
gt;
gt;
gt;

Instead of $K$15 in cell A15 put $K15 in cell A15. Then copy / paste
A15 down through A? as far as you want. edSelect 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=quot;noquot;

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=quot;noquot;

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

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Susan Reneequot; gt; wrote in message
...
gt; How do I copy that down a row of cells.
gt;
gt; For example, If K12=No, then I want A12 to be red, bold.
gt; If K13=No, then I want A13 to be red, bold.
gt; and so forth.
gt;
gt; --
gt; Thanks for your help.
gt;
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Select A15, do formatgt;conditional formatting, select formula is from
gt;gt; condition1 dropdown and put
gt;gt;
gt;gt; =$K$15=quot;noquot;
gt;gt;
gt;gt; in the formula is box
gt;gt; click the format button and select red and bold fonts and click OK twice
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt; quot;Susan Reneequot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to make the result of a cell Red and Bold if the cell result
gt;gt; gt;of
gt;gt; gt;a
gt;gt; gt; formula is past due.
gt;gt; gt;
gt;gt; gt; For example: I have a cell(A15) that is a client name. In cell #K15,
gt;gt; gt; the
gt;gt; gt; cells say either Yes or No.
gt;gt; gt;
gt;gt; gt; I want the client name to be Red in cell #A15 if the cell #K15 is no.
gt;gt; gt;
gt;gt; gt; Can anyone help?
gt;gt; gt; --
gt;gt; gt; Thanks for your help.
gt;gt;
gt;gt;
gt;gt;