conditional formatting syntax
 

Hello, What syntax can i use to highlight cells that are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with the
g32 beingthe active cell.

conditional formatting syntax
 

Hi
you may try the following formula
=AND(G32=DATE(2004,1,26),G32<=DATE(2004,2,25))

--
Regards
Frank Kabel
Frankfurt, Germany

mlm wrote:
Hello, What syntax can i use to highlight cells that are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with the
g32 beingthe active cell.

conditional formatting syntax
 

Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<=D ate(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month($G$32),26)
in the second condition =Date(Year($G$32),Month($G$32)+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with the
g32 beingthe active cell.

conditional formatting syntax
 

okay thanks,

Will this also work for when there is more than one cylce
ina range of cells? how do i apply this to alternate
clors from one month cycle to next?? two conditionals
alike?
-----Original Message-----
Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<= Date
(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month
($G$32),26)
in the second condition =Date(Year($G$32),Month($G$32)
+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that
are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with
the
g32 beingthe active cell.


.

conditional formatting syntax
 

What I mean is that ina range there could be more than
one cycle. first one is chagned then the next can be from
original format then 3rd cylce? how can we affect that
one? Loop or not equal to first argument?
-----Original Message-----
Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<= Date
(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month
($G$32),26)
in the second condition =Date(Year($G$32),Month($G$32)
+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that
are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with
the
g32 beingthe active cell.


.

conditional formatting syntax
 

This will work for a given date in G32 that identifies Month 1 for the
range G32 to AT32 filled with dates. Month 2 is defined as the month
following Month 1.

The remainder of your question is unintelligible. Cycle is meaningless to
me. Alternate colors from one month cycle to the next is meaningless to me.
Two conditionals alike? means nothing to me.

--
Regards,
Tom Ogilvy

"mlm" wrote in message
...
okay thanks,

Will this also work for when there is more than one cylce
ina range of cells? how do i apply this to alternate
clors from one month cycle to next?? two conditionals
alike?
-----Original Message-----
Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<= Date
(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month
($G$32),26)
in the second condition =Date(Year($G$32),Month($G$32)
+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that
are
in the date range between of 26th of Month1 to 25th of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2 in
conditional formtting as a formula but cant seem to get
it down here. my range of cell is G32 thru AT32 with
the
g32 beingthe active cell.


.

conditional formatting syntax
 

okay , i was typing in a hurry,

lets say the cell range is at 60 days.
the first 5 could be the current date starting with
say..3-27-04...then the cell follows would include the
next month april and then the remainder would have the
beginning of may. correct?
i was refferring cycles to the months that occur n the
range of days. my question was that after the first and
the second month has been detected and changed acording
to the format how about the third month???

and the formula you have given is for the current monht
which is great when in current month but if i had to go
back & redo the dates that isnt current then , the
formatting wont work. I wanted to knwo if there was a way
to do it with all dates current or past.

-----Original Message-----
This will work for a given date in G32 that identifies
Month 1 for the
range G32 to AT32 filled with dates. Month 2 is defined
as the month
following Month 1.

The remainder of your question is unintelligible. Cycle
is meaningless to
me. Alternate colors from one month cycle to the next
is meaningless to me.
Two conditionals alike? means nothing to me.

--
Regards,
Tom Ogilvy

"mlm" wrote in message
...
okay thanks,

Will this also work for when there is more than one
cylce
ina range of cells? how do i apply this to alternate
clors from one month cycle to next?? two conditionals
alike?
-----Original Message-----
Select G32 to AT32 with G32 as the active Cell
Go to Format=Conditional formatting
change cell value is to formula is in the first
dropdown

=And(G32=Date(year($G$32),month($G$32),26),G32<= Date
(Year($G$32),Month($G$3
2)+1,25))

or leave it as Cell Value is and use Between,
in the first condition =Date(year($G$32),month
($G$32),26)
in the second condition =Date(Year($G$32),Month
($G$32)
+1,25)

Include the "=" sign.
--
Regards,
Tom Ogilvy


"mlm" wrote in message
...
Hello, What syntax can i use to highlight cells that
are
in the date range between of 26th of Month1 to 25th
of
month2? Do i use in between or ....
I thought of using the AND suntax with month1 and 2
in
conditional formtting as a formula but cant seem to
get
it down here. my range of cell is G32 thru AT32 with
the
g32 beingthe active cell.


.



.