show fill color of a shaded row

[worldtraveler]

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.

 

[Gord Dibben]

Remove CF from that row?

Change CF fill to yellow for that row?


Gord Dibben MS Excel MVP

 

[Victor Delta]

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

 

[Shane Devenshire]

Hi,

Excel's order of priority is:

Conditional Formatting > Manual Formatting > Table Styles

In other words Conditional Formatting wins.