How to conditional format columns in a range based on

[BlyChris]

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
†€€ˆ€€€€ˆ€€€€€Š€€ˆ€€€€ˆ€€€€€Š€
HrsEmps # Jobs HrsEmps # Jobs
„€€‰€€€€‰€€€€€‰€€‰€€€€‰€€€€€

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

 

[Bernie Deitrick]

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

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


HTH,
Bernie
MS Excel MVP


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
†€€ˆ€€€€ˆ€€€€€Š€€ˆ€€€€ˆ€€€€€Š€
HrsEmps # Jobs HrsEmps # Jobs
„€€‰€€€€‰€€€€€‰€€‰€€€€‰€€€€€

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

 

[Bernie Deitrick]

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

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

HTH,
Bernie
MS Excel MVP


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
†€€ˆ€€€€ˆ€€€€€Š€€ˆ€€€€ˆ€€€€€Š€
HrsEmps # Jobs HrsEmps # Jobs
„€€‰€€€€‰€€€€€‰€€‰€€€€‰€€€€€

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

 

[T. Valko]

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


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
†€€ˆ€€€€ˆ€€€€€Š€€ˆ€€€€ˆ€€€€€Š€
HrsEmps # Jobs HrsEmps # Jobs
„€€‰€€€€‰€€€€€‰€€‰€€€€‰€€€€€

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

 

[BlyChris]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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