show fill color of a shaded row

  • Thread starter Thread starter worldtraveler
  • Start date Start date
W

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.
 
Remove CF from that row?

Change CF fill to yellow for that row?


Gord Dibben MS Excel MVP
 
worldtraveler said:
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.
Click to expand...

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