How to conditional format columns in a range based on

B

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

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top