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

C

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!
 
R

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
 
D

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
 
Top