can someone help me with this problems please?

S

SunTzuComm

Use the following menu path:

Format --> Conditional formatting...

To change the background color, click the "Format..." button on the dialog and
then choose the "Patterns" tab.

Regards,
Wes
 
G

Gord Dibben

Debbie

Select the entire row by clicking on the row header.

Format>Conditional Formatting>Formula is =$A$1="debbie"

Choose a nice formatting pattern and OK your way out.

Note the $ signs in the formula. They must be present.

Your cell address and data value will perhaps differ from the example above.

Gord Dibben Excel MVP
 
D

DEBBZ :

GORD DIBBEN Your a star just what i wanted :)
the line i put in was =$J$13="paypal"
Which means that the whole line changed what ever color i wanted
is i chose paypal from the drop down list. :) Thanx a lot
 
D

DEBBZ :

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>? :)
 
D

Dave Peterson

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
 
Top