In Excel 2007, I shaded even rows using conditional formating (light green),
and have one row that is filled (yellow). I want the yellow fill to show,
but it is hidden behind the row shading. I know it is there because when the
row is highlighted, under the fill color bucket drop down, it shows the color
outlined in the standard colors list. How do I get it to show up, as being
the top or primary color for the row?
Thanks in advance for help.

Remove CF from that row?

Change CF fill to yellow for that row?


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 14:52:01 -0700, worldtraveler
wrote:

In Excel 2007, I shaded even rows using conditional formating (light green),
and have one row that is filled (yellow). I want the yellow fill to show,
but it is hidden behind the row shading. I know it is there because when the
row is highlighted, under the fill color bucket drop down, it shows the color
outlined in the standard colors list. How do I get it to show up, as being
the top or primary color for the row?
Thanks in advance for help.

"worldtraveler" wrote in message
...
In Excel 2007, I shaded even rows using conditional formating (light
green),
and have one row that is filled (yellow). I want the yellow fill to show,
but it is hidden behind the row shading. I know it is there because when
the
row is highlighted, under the fill color bucket drop down, it shows the
color
outlined in the standard colors list. How do I get it to show up, as
being
the top or primary color for the row?
Thanks in advance for help.

Either remove the conditional formatting rule for the yellow row OR add a
new, higher, conditional formatting rule that makes the appropriate row
yellow.

V

Hi,

Excel's order of priority is:

Conditional Formatting Manual Formatting Table Styles

In other words Conditional Formatting wins.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"worldtraveler" wrote:

In Excel 2007, I shaded even rows using conditional formating (light green),
and have one row that is filled (yellow). I want the yellow fill to show,
but it is hidden behind the row shading. I know it is there because when the
row is highlighted, under the fill color bucket drop down, it shows the color
outlined in the standard colors list. How do I get it to show up, as being
the top or primary color for the row?
Thanks in advance for help.