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
‚€€€€€€€€€€€€€ˆ€€€€€€€€€€€€€ˆ€
� 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.

How to conditional format columns in a range based on
 

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

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


HTH,
Bernie
MS Excel MVP


"BlyChris" wrote in message
...
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.

How to conditional format columns in a range based on
 

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" wrote in message
...
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.

How to conditional format columns in a range based on
 

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 FormatConditional 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" wrote in message
...
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.

How to conditional format columns in a range based on
 

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?k...GbOLC1KcztYZJw

Chris


On Jul 24, 12:58*pm, "T. Valko" 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 FormatConditional 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" wrote in message

...
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.

How to conditional format columns in a range based on
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"BlyChris" wrote in message
...
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?k...GbOLC1KcztYZJw

Chris


On Jul 24, 12:58 pm, "T. Valko" 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 FormatConditional 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" wrote in message

...
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.