How To Copy Conditional Formatting to Several (1,000) Cells

[Cameron Dockstader]

I get the whole Conditional Formatting thing, so I'm not looking for a
tutorial. However, I can not figure this one out. What I need, is an
individual row to be highlighted a certain color, depending on the content of
one of its cells. Sounds easy enough right, well, I need to have this on
about a thousand rows, and for some reason, when I enter K1 as the dynamic
cell reference, instead of $K$1 as the static reference, it changes all
thousand rows by whatever is in K1. . .


Help me!!

Thanks!

[Ron Coderre]

You didn't post what formula you are using, so I'll just use an example:

Select rows 1 through 1000), with Row_1 as the active row

<Format><Conditional Formatting>
Formula is: =($A1>0)
Click the [Format] button and set the format
Click the [OK] buttons to finish

After that, whenever the value in any cell in A1:A1000 is greater than 0,
the entire respective row will use the CF.

(Note the dollar sign in the "Formula is" section)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Cameron Dockstader" wrote:

> I get the whole Conditional Formatting thing, so I'm not looking for a
> tutorial. However, I can not figure this one out. What I need, is an
> individual row to be highlighted a certain color, depending on the content of
> one of its cells. Sounds easy enough right, well, I need to have this on
> about a thousand rows, and for some reason, when I enter K1 as the dynamic
> cell reference, instead of $K$1 as the static reference, it changes all
> thousand rows by whatever is in K1. . .
>
>
> Help me!!
>
> Thanks!

[David McRitchie]

Interesting that you say you don't need a tutorial, and use a cell reference of $K$1
instead of $K1 , so I guess you wouldn't be needing
http://www.mvps.org/dmcritchie/excel/condfmt.htm
and of course the cell references that you use are relative to the active cell
so I expect you want to be anywhere on row 1 when you use a formula
with $K1 in it, and assuming you have no other surprises. Don't forget
to select all of the cells on the worksheet when entering your conditional formatting
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Cameron Dockstader" <[email protected]> wrote in message
news:[email protected]...
> I get the whole Conditional Formatting thing, so I'm not looking for a
> tutorial. However, I can not figure this one out. What I need, is an
> individual row to be highlighted a certain color, depending on the content of
> one of its cells. Sounds easy enough right, well, I need to have this on
> about a thousand rows, and for some reason, when I enter K1 as the dynamic
> cell reference, instead of $K$1 as the static reference, it changes all
> thousand rows by whatever is in K1. . .
>
>
> Help me!!
>
> Thanks!