|
conditional formatting formula
what would the 2 formulas be to alternate cell colors in the date groups?
1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
conditional formatting formula
Gary,
I have placed a spreadsheet at http://www.HelpExcel.com/examples. The name is alternate.xls -- http://HelpExcel.com "Gary Keramidas" wrote: what would the 2 formulas be to alternate cell colors in the date groups? 1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
conditional formatting formula
thanks, but don't want to alternate, know how to do that. i need to each group
of the same dates one color, then the next group the other color 1/2/2007 <- blue 1/2/2007<- blue 1/2/2007<- blue 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/7/2007<- blue (days skipped here as not every date will be entered) -- Gary "galimi" wrote in message ... Gary, I have placed a spreadsheet at http://www.HelpExcel.com/examples. The name is alternate.xls -- http://HelpExcel.com "Gary Keramidas" wrote: what would the 2 formulas be to alternate cell colors in the date groups? 1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
conditional formatting formula
i wrote some code for now in lieu of conditional formatting.
-- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what would the 2 formulas be to alternate cell colors in the date groups? 1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
conditional formatting formula
I think code is your solution, it is not easy (possible) to keep track in CF
where the last colour was used. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks, but don't want to alternate, know how to do that. i need to each group of the same dates one color, then the next group the other color 1/2/2007 <- blue 1/2/2007<- blue 1/2/2007<- blue 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/7/2007<- blue (days skipped here as not every date will be entered) -- Gary "galimi" wrote in message ... Gary, I have placed a spreadsheet at http://www.HelpExcel.com/examples. The name is alternate.xls -- http://HelpExcel.com "Gary Keramidas" wrote: what would the 2 formulas be to alternate cell colors in the date groups? 1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
conditional formatting formula
ok, thanks bob.
-- Gary "Bob Phillips" wrote in message ... I think code is your solution, it is not easy (possible) to keep track in CF where the last colour was used. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... thanks, but don't want to alternate, know how to do that. i need to each group of the same dates one color, then the next group the other color 1/2/2007 <- blue 1/2/2007<- blue 1/2/2007<- blue 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/4/2007<- white 1/7/2007<- blue (days skipped here as not every date will be entered) -- Gary "galimi" wrote in message ... Gary, I have placed a spreadsheet at http://www.HelpExcel.com/examples. The name is alternate.xls -- http://HelpExcel.com "Gary Keramidas" wrote: what would the 2 formulas be to alternate cell colors in the date groups? 1/2/2007 1/2/2007 1/2/2007 1/4/2007 1/4/2007 1/4/2007 1/4/2007 1/5/2007 -- Gary |
| All times are GMT +1. The time now is 07:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com