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)

<format<conditional formatting
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
<edit<copy
Select the other cells to receive the CF
<edit<paste special<formats...Click the [OK] button

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

XL2002, WinXP


"Susan Renee" wrote:

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.

Hi Ron,

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

Peo


"Ron Coderre" wrote in message
...
Try this:

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

<format<conditional formatting
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
<edit<copy
Select the other cells to receive the CF
<edit<paste special<formats...Click the [OK] button

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

XL2002, WinXP


"Susan Renee" wrote:

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.

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

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

<format<conditional formatting
Formula is: =($K12="No")
Click the [format] button and set the format
Click [OK] buttons

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

XL2002, WinXP


"Peo Sjoblom" wrote:

Hi Ron,

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

Peo


"Ron Coderre" wrote in message
...
Try this:

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

<format<conditional formatting
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
<edit<copy
Select the other cells to receive the CF
<edit<paste special<formats...Click the [OK] button

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

XL2002, WinXP


"Susan Renee" wrote:

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.