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.