I have set up a rule for changing the color in a specific cell, depending on which text option i choose in a drop down list, but what if I want the whole row to attain that same color?? is that possible?

I don't use 2007, so I'll assume that by "rule" you mean that you are using Conditional Formatting. In 2003 I selected Row 10 by clicking on the row number and then used: Format...Conditional Formatting...Formula Is... Condition 1: =IF($A$1="Blue",TRUE,FALSE) Format...Patterns...Click Blue Condition 2: =IF($A$1="Red",TRUE,FALSE) Format...Patterns...Click Red I put a Drop Down in A1 containing Blue and Red. Whichever color I choose, that's the color that Row 10 becomes.

Doesn't work in 2007... or not for me at least :(

"Doesn't work" is kind of generic. A little more detail might help.

Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a load more options for conditional formatting than 2003. Select the whole of a row, then goto Home - Styles - Conditional Formatting - Manage Rules Click new rule Select 'use a formula to determine ...' Enter =IF($A$1="Blue",TRUE,FALSE) in the box Set the format (blue fill) click OK The Applies to box should already have $10:$10 if that is the row you selected. Repeat the new rule for the Red option. Click OK until conditional formatting box closes. Enter Blue in cell A1 and the whole row goes blue, or enter Red in cell A1 ... Regards

Hi, As you say that you already have conditional formatting working for one cell, you should be able to change the range of cells the rule applies to by changing from a single cell in the 'Applies To' box, to the address for the whole row. Regards

Thank you very much for your helpful answers. I have tried all the options you have given me now. I HAVE entered the formulas correctly but still can't seem to get it to work.. I have tried both using the name of the color in the equation, and also the name of the box-text, but neither works. Nothing happens once I have applied the conditional formatting to the specific row. As for expanding the "applies-to" box, this does not work either, as the conditional formatting that has already been set up is based on the text in the specific cell. I will give you a more detailed description of my setup: The options in my drop-down menu are: New - returning the color (no color) Evaluated - returning the color (blue) Assigned - returning the color (yellow) In progress - returning the color (orange) Finished - returning the color (green) the formatting has been set up in conditional formatting - reacting to cells with a "particular text" and "starting with" the options, and then finally applied to the whole spreadsheet Thank You