software

How do I copy a conditional format formula 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.
If K14=No, then I want A14 to be red, bold.
and so forth.

--
Thanks for your help.

Try this:

To create the CF for a range:
Select from K12 to the bottom of your list (with K12 as the Active Cell)

lt;formatgt;lt;conditional formattinggt;
Cell value is: equal to No
Click the [format] button and set the format
Click [OK] buttons

OR.....once you already have that CF in a cell

Select the cell
lt;editgt;lt;copygt;
Select the other cells to receive the CF
lt;editgt;lt;paste specialgt;lt;formatsgt;...Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXPquot;Susan Reneequot; wrote:

gt; How do I copy a conditional format formula down a row of cells?
gt;
gt; For example,
gt; If K12=No, then I want A12 to be red, bold.
gt; If K13=No, then I want A13 to be red, bold.
gt; If K14=No, then I want A14 to be red, bold.
gt; and so forth.
gt;
gt;
gt;
gt;
gt; --
gt; Thanks for your help.

Hi Ron,

I believe she wanted the values in A to be formatted depending on values in
K

Peoquot;Ron Coderrequot; gt; wrote in message
...
gt; Try this:
gt;
gt; To create the CF for a range:
gt; Select from K12 to the bottom of your list (with K12 as the Active Cell)
gt;
gt; lt;formatgt;lt;conditional formattinggt;
gt; Cell value is: equal to No
gt; Click the [format] button and set the format
gt; Click [OK] buttons
gt;
gt; OR.....once you already have that CF in a cell
gt;
gt; Select the cell
gt; lt;editgt;lt;copygt;
gt; Select the other cells to receive the CF
gt; lt;editgt;lt;paste specialgt;lt;formatsgt;...Click the [OK] button
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;Susan Reneequot; wrote:
gt;
gt;gt; How do I copy a conditional format formula down a row of cells?
gt;gt;
gt;gt; For example,
gt;gt; If K12=No, then I want A12 to be red, bold.
gt;gt; If K13=No, then I want A13 to be red, bold.
gt;gt; If K14=No, then I want A14 to be red, bold.
gt;gt; and so forth.
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Thanks for your help.
Peo....Thanks so much for catching that!
(I'll give myself a newspaper over the snout for missing something so
obvious.)

Susan: Try this, instead of my previous post:

Assuming you want the Col_A values formatted to reflect if the Col_K value
is quot;Noquot;...

To create the CF:
Select from A12 to the bottom of your Col_A list (with A12 as the Active Cell)

lt;formatgt;lt;conditional formattinggt;
Formula is: =($K12=quot;Noquot;)
Click the [format] button and set the format
Click [OK] buttons

Hopefully, that helps.
***********
Regards,
Ron

XL2002, WinXPquot;Peo Sjoblomquot; wrote:

gt; Hi Ron,
gt;
gt; I believe she wanted the values in A to be formatted depending on values in
gt; K
gt;
gt; Peo
gt;
gt;
gt; quot;Ron Coderrequot; gt; wrote in message
gt; ...
gt; gt; Try this:
gt; gt;
gt; gt; To create the CF for a range:
gt; gt; Select from K12 to the bottom of your list (with K12 as the Active Cell)
gt; gt;
gt; gt; lt;formatgt;lt;conditional formattinggt;
gt; gt; Cell value is: equal to No
gt; gt; Click the [format] button and set the format
gt; gt; Click [OK] buttons
gt; gt;
gt; gt; OR.....once you already have that CF in a cell
gt; gt;
gt; gt; Select the cell
gt; gt; lt;editgt;lt;copygt;
gt; gt; Select the other cells to receive the CF
gt; gt; lt;editgt;lt;paste specialgt;lt;formatsgt;...Click the [OK] button
gt; gt;
gt; gt; Does that help?
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP
gt; gt;
gt; gt;
gt; gt; quot;Susan Reneequot; wrote:
gt; gt;
gt; gt;gt; How do I copy a conditional format formula down a row of cells?
gt; gt;gt;
gt; gt;gt; For example,
gt; gt;gt; If K12=No, then I want A12 to be red, bold.
gt; gt;gt; If K13=No, then I want A13 to be red, bold.
gt; gt;gt; If K14=No, then I want A14 to be red, bold.
gt; gt;gt; and so forth.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Thanks for your help.
gt;
gt;
gt;