View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default show fill color of a shaded row

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.