can someone help me with this problems please?

[DEBBZ :]

i have a link so u can download the xls file. its realy basic but
im stuck i want to change a row to a different color when a cell
has a certain value in there is that possible? anyway if anyone
gets time i would be very happy and heres the link TIA DEBBZ
http://homepage.ntlworld.com/psxchip/selling.xls

 

[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

 

[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

 

[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

 

[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>?

 

[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