ExcelBanter - can someone help me with this problems please? GORD YOUR A STAR :) thnx BUTTTTTT!

You could do one row and then copy it.
then select the other rows and do edit|paste special|and click formats.

But you'll want to change the formul so that it looks at the current row.

=$A$1="debbie"
will become:
=$A1="debbie"

So when you paste, excel will adjust that row number to match the current
row--just like when you copy a formula.

But since you're going to adjust the formula, you might as well get all the
range at once:

Select your range (A1:X999 include all the columns and rows you want formatted)

Then format|conditional formatting
Write your formula for the active cell:

=$A1="debbie"

When you hit ok, excel will adjust the formula for each cell in the selection.

Just like when you select a multicell range and type a formula and hit
ctrl-enter instead of just enter.

The $A says to never adjust that column in the formula.

The 1 doesn't have a $ sign. It gets adjusted.

(You can read more about this stuff in Excel's help.
Look for: Address
then click on "About cell and range references" in the topic box

DEBBZ : wrote:

is there a auick qay i can do multiple lines and apply the same
condition to them all without doing them 1 at a time? :)

----------------------------------------------
Posted with NewsLeecher v1.0 beta 23
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

--

Dave Peterson