Color formatting in Excel 2007

September 24, 2009 at 02:21:42
Specs: Windows XP
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

See More: Color formatting in Excel 2007

Report •

September 24, 2009 at 05:43:57
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.

Report •

September 24, 2009 at 06:01:58
Doesn't work in 2007... or not for me at least :(

Report •

September 24, 2009 at 07:49:13
"Doesn't work" is kind of generic.

A little more detail might help.

Report •

Related Solutions

September 24, 2009 at 09:39:17

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 ...


Report •

September 24, 2009 at 09:41:38

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.


Report •

September 25, 2009 at 01:02:27
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

Report •

September 25, 2009 at 04:33:37

From your reply, I am not entirely clear how this is meant to work.

Is this what you have:
Rows of data (i.e., records) which may be New, Evaluated etc.

There is a drop down list in a cell at the start of each row (record) which has the list of these statuses (New, Evaluated etc.)

and the row (record) is coloured according to the status selected for it.

Please let us know, and then someone can offer a more specific option.

One other thing, as the option to colour a whole row based on the text selected in one cell does work - I have it working on Excel 2007 - you should try and get the example working. Perhaps try it out on a new workbook, with no existing conditional formatting.


Report •

September 25, 2009 at 05:12:21
Figured it out...

Thank you very much for your replies

Report •

September 25, 2009 at 05:25:05
re: Figured it out...

Why not share with us how you "figured it out"?

Since we put in the effort to help you, it would be nice to know what the problem was as well as the final solution.

It might help us help others in the future.

Report •

Ask Question