View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Cell shading with conditional formatting

Are the gray cells set with conditional formatting?

The conditional formatting of the banded rows will have precedence over
manual formatting. If the gray cells are conditionally formatted then set
that formatting first as condition 1 then set the row banding as condition
2.

Biff

"tjsmags" wrote in message
...
I use the following conditional formatting formula =MOD(ROW(),2)+1<=1 to
alternate colors for my spreadsheet. Whenever I insert a row it will
automatically adjust the rows to be alternating colors. But, I cell shade
(using light grey) some of the cells in this spreadsheet. Some of these
greyed cells are on the WHITE rows and some are on the LIGHT BLUE rows
(relating to the conditional formatting formula). I cannot see the greyed
out cells when they're on the light blue rows (it doesn't show up). How
can
I fix this?