How to conditional format columns in a range based on

I have a spreadsheet that has many columns, essential I have a header
for a group of three columns which is a merge of three column cells to
make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
want to apply a conditional format tot the merged cells within the
range that has the current month in it. here is an example of what I
have:

Starts in column E2 on Row 2
(I want to highlight the merged cells that equal the current month
based on date in $A$1
=82=80=80=80=80=80=80=80=80=80=80=80=80=80=88=80=80=80=80=80=80=80=80=80=80=
=80=80=80=88=80
=81 Jan-08 =81 Feb-08 =81------->
Dec-08
=86=80=80=88=80=80=80=80=88=80=80=80=80=80=8A=80=80=88=80=80=80=80=88=80=80=
=80=80=80=8A=80
=81Hrs=81Emps =81# Jobs =81Hrs=81Emps =81# Jobs =81
=84=80=80=89=80=80=80=80=89=80=80=80=80=80=89=80=80=89=80=80=80=80=89=80=80=
=80=80=80

Thanks, sorry about the crude drawing. but wanted to make sure it was
understood.

Bernie
Thu Jul 24 12:53:54 CDT 2008

Select row 1, apply CF with the "Formula is" option, and the formula

=MONTH(A1)=MONTH(NOW())


HTH,
Bernie
MS Excel MVP


"BlyChris" <csmith77571@gmail.com> wrote in message
news:9b50fe01-9a43-4923-907a-ee21aa5532fc@m45g2000hsb.googlegroups.com...
I have a spreadsheet that has many columns, essential I have a header
for a group of three columns which is a merge of three column cells to
make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
want to apply a conditional format tot the merged cells within the
range that has the current month in it. here is an example of what I
have:

Starts in column E2 on Row 2
(I want to highlight the merged cells that equal the current month
based on date in $A$1
??????????????????????????????
? Jan-08 ? Feb-08 ?------->
Dec-08
??????????????????????????????
?Hrs?Emps ?# Jobs ?Hrs?Emps ?# Jobs ?
????????????????????????????

Thanks, sorry about the crude drawing. but wanted to make sure it was
understood.

Bernie
Thu Jul 24 12:55:10 CDT 2008

Or, upon further reading, select row 2, and use the formula is option with

=MONTH(A2)=MONTH($A$1)

HTH,
Bernie
MS Excel MVP


"BlyChris" <csmith77571@gmail.com> wrote in message
news:9b50fe01-9a43-4923-907a-ee21aa5532fc@m45g2000hsb.googlegroups.com...
I have a spreadsheet that has many columns, essential I have a header
for a group of three columns which is a merge of three column cells to
make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
want to apply a conditional format tot the merged cells within the
range that has the current month in it. here is an example of what I
have:

Starts in column E2 on Row 2
(I want to highlight the merged cells that equal the current month
based on date in $A$1
??????????????????????????????
? Jan-08 ? Feb-08 ?------->
Dec-08
??????????????????????????????
?Hrs?Emps ?# Jobs ?Hrs?Emps ?# Jobs ?
????????????????????????????

Thanks, sorry about the crude drawing. but wanted to make sure it was
understood.

T
Thu Jul 24 12:58:53 CDT 2008

Let's see if I understand what your layout is like.

E2:G2 = merged cells = date formatted as Jan/yy
H2:J2 = merged cells = date formatted as Feb/yy
K2:M2 = merged cells = date formatted as Mar/yy
..
AL2:AN2 = merged cells = date formatted as Dec/yy

If that's the case selct the range E2:AL2
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=AND(COUNT($A1,E2)=2,MONTH(E2)=MONTH($A1))

Click the Format button
Select the desired style(s)
OK out


--
Biff
Microsoft Excel MVP


"BlyChris" <csmith77571@gmail.com> wrote in message
news:9b50fe01-9a43-4923-907a-ee21aa5532fc@m45g2000hsb.googlegroups.com...
I have a spreadsheet that has many columns, essential I have a header
for a group of three columns which is a merge of three column cells to
make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
want to apply a conditional format tot the merged cells within the
range that has the current month in it. here is an example of what I
have:

Starts in column E2 on Row 2
(I want to highlight the merged cells that equal the current month
based on date in $A$1
??????????????????????????????
? Jan-08 ? Feb-08 ?------->
Dec-08
??????????????????????????????
?Hrs?Emps ?# Jobs ?Hrs?Emps ?# Jobs ?
????????????????????????????

Thanks, sorry about the crude drawing. but wanted to make sure it was
understood.

BlyChris
Thu Jul 24 23:53:38 CDT 2008

Thanks! It Worked. I don't know why I could not figure that out, I
tried everything but that. I guess I was not thinking the right way.

Here is where you can see the example:
http://spreadsheets.google.com/pub?key=3Dp36rltTG6GbOLC1KcztYZJw

Chris


On Jul 24, 12:58=A0pm, "T. Valko" <biffinp...@comcast.net> wrote:
> Let's see if I understand what your layout is like.
>
> E2:G2 =3D merged cells =3D date formatted as Jan/yy
> H2:J2 =3D merged cells =3D date formatted as Feb/yy
> K2:M2 =3D merged cells =3D date formatted as Mar/yy
> ..
> AL2:AN2 =3D merged cells =3D date formatted as Dec/yy
>
> If that's the case selct the range E2:AL2
> Goto the menu Format>Conditional Formatting
> Select the Formula Is option
> Enter this formula in the little box on the right:
>
> =3DAND(COUNT($A1,E2)=3D2,MONTH(E2)=3DMONTH($A1))
>
> Click the Format button
> Select the desired style(s)
> OK out
>
> --
> Biff
> Microsoft Excel MVP
>
> "BlyChris" <csmith77...@gmail.com> wrote in message
>
> news:9b50fe01-9a43-4923-907a-ee21aa5532fc@m45g2000hsb.googlegroups.com...
> I have a spreadsheet that has many columns, essential I have a header
> for a group of three columns which is a merge of three column cells to
> make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
> want to apply a conditional format tot the merged cells within the
> range that has the current month in it. here is an example of what I
> have:
>
> Starts in column E2 on Row 2
> =A0(I want to highlight the merged cells that equal the current month
> based on date in $A$1
> =82=80=80=80=80=80=80=80=80=80=80=80=80=80=88=80=80=80=80=80=80=80=80=80=
=80=80=80=80=88=80
> =A0 =A0 =A0 =A0 =A0Jan-08 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Feb-08 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0------->
> Dec-08
> =86=80=80=88=80=80=80=80=88=80=80=80=80=80=8A=80=80=88=80=80=80=80=88=80=
=80=80=80=80=8A=80
> =A0Hrs Emps =A0# Jobs =A0 Hrs Emps =A0# Jobs =A0
> =84=80=80=89=80=80=80=80=89=80=80=80=80=80=89=80=80=89=80=80=80=80=89=80=
=80=80=80=80
>
> Thanks, sorry about the crude drawing. but wanted to make sure it was
> understood.

T
Fri Jul 25 00:10:42 CDT 2008

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"BlyChris" <csmith77571@gmail.com> wrote in message
news:c38a3475-e24c-4d16-b7f2-3284ee1210d9@n33g2000pri.googlegroups.com...
Thanks! It Worked. I don't know why I could not figure that out, I
tried everything but that. I guess I was not thinking the right way.

Here is where you can see the example:
http://spreadsheets.google.com/pub?key=p36rltTG6GbOLC1KcztYZJw

Chris


On Jul 24, 12:58 pm, "T. Valko" <biffinp...@comcast.net> wrote:
> Let's see if I understand what your layout is like.
>
> E2:G2 = merged cells = date formatted as Jan/yy
> H2:J2 = merged cells = date formatted as Feb/yy
> K2:M2 = merged cells = date formatted as Mar/yy
> ..
> AL2:AN2 = merged cells = date formatted as Dec/yy
>
> If that's the case selct the range E2:AL2
> Goto the menu Format>Conditional Formatting
> Select the Formula Is option
> Enter this formula in the little box on the right:
>
> =AND(COUNT($A1,E2)=2,MONTH(E2)=MONTH($A1))
>
> Click the Format button
> Select the desired style(s)
> OK out
>
> --
> Biff
> Microsoft Excel MVP
>
> "BlyChris" <csmith77...@gmail.com> wrote in message
>
> news:9b50fe01-9a43-4923-907a-ee21aa5532fc@m45g2000hsb.googlegroups.com...
> I have a spreadsheet that has many columns, essential I have a header
> for a group of three columns which is a merge of three column cells to
> make one cell and has a date (01/01/08) in it formatted to "mmm/yy". I
> want to apply a conditional format tot the merged cells within the
> range that has the current month in it. here is an example of what I
> have:
>
> Starts in column E2 on Row 2
> (I want to highlight the merged cells that equal the current month
> based on date in $A$1
> ??????????????????????????????
> Jan-08 Feb-08 ------->
> Dec-08
> ??????????????????????????????
> Hrs Emps # Jobs Hrs Emps # Jobs
> ????????????????????????????
>
> Thanks, sorry about the crude drawing. but wanted to make sure it was
> understood.