| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an If Formula with Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting in a formula | Excel Discussion (Misc queries) | |||
| conditional formatting OR formula | Excel Discussion (Misc queries) | |||
| Conditional formatting and formula | Excel Worksheet Functions | |||
| Conditional Formatting Formula | Excel Worksheet Functions | |||
Linear Mode
