conditional formatting >syntax

  • Thread starter Thread starter mlm
  • Start date Start date
M

mlm

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.
 
Hi
you may try the following formula
=AND(G32>=DATE(2004,1,26),G32<=DATE(2004,2,25))
 
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.
 
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?
 
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?
 
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.
 
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.
 
if you want the current month to be today's month

the first condition

for cell G32 as the active cell

=Month(G32)=Mod(month(Today()),12)+1

second condition

=Month(G32)<>month(Today())

This will give you a combination of 3 colors. current month is the
untouched background, next month is the color for condition 1, andy other
month is the color for condition 2.
 
Back
Top