Conditional Formula

[Guest]

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.

 

[Guest]

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

 

[Peo Sjoblom]

Hi Ron,

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

Peo

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

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.

 

[Guest]

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

Hi Ron,

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

Peo

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

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.