Conditional Formatting

Bazola

New Member
Joined
Mar 14, 2018
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Hi All

I am hoping this will be a quick one!

I've got a spreadsheet with some columns in it, at the top it says the date such as Mar-19, next column says Apr-19 and so on. I want to use CF to highlight the current month and the associated cells below column wise. So for example,
Mar-19 is cell D4, the cells I also want to be highlighted as part of it are Cells D5-D8.

Your help is appreciated :)
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,395
Office Version
  1. 2016
Platform
  1. Windows
Select rows 4-8
CF formula : =MONTH(A$4)=MONTH(TODAY())
 
Last edited:

Bazola

New Member
Joined
Mar 14, 2018
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Select rows 4-8
CF formula : =MONTH(A$4)=MONTH(TODAY())

Brilliant, thank you. I presume If I want to do the same for the other columns, do I need to do a seperate formula for each one or just change the "Applies to" to include the bigger selection?

Thanks
 

Bazola

New Member
Joined
Mar 14, 2018
Messages
34
Office Version
  1. 365
Platform
  1. Windows
When I change the "Applies to" include all the other cells with the other months + figures below, it also highlights Mar-20 as well? Instead of Just Mar-19? Any ideas?
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,395
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

I presume If I want to do the same for the other columns, do I need to do a seperate formula for each one or just change the "Applies to" to include the bigger selection?
No. The "Applies to" ($4:$8 - i.e. rows 4:8) already covers all columns.
When I change the "Applies to" include all the other cells with the other months + figures below, it also highlights Mar-20 as well? Instead of Just Mar-19? Any ideas?
It is not clear what you want to do.
 

Bazola

New Member
Joined
Mar 14, 2018
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Sorry for not explaining properly. I have a number of column with say:

March 19
Apr 19
June 19
and so on

Underneath each column, I have figures. Basically I want CF to highlight the particular column all the cells. So if its March 19, I want that entire column to be red, and the rest stay white. But I want as little formulas as possible
 

josvill2010

New Member
Joined
Jun 1, 2011
Messages
35
Office Version
  1. 365

ADVERTISEMENT

Sorry for not explaining properly. I have a number of column with say:

March 19
Apr 19
June 19
and so on

Underneath each column, I have figures. Basically I want CF to highlight the particular column all the cells. So if its March 19, I want that entire column to be red, and the rest stay white. But I want as little formulas as possible


I have the same question. What I have done is copy the formula to the next column
 

Bazola

New Member
Joined
Mar 14, 2018
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Sorry for not explaining properly. I have a number of column with say:

March 19
Apr 19
June 19
and so on

Underneath each column, I have figures. Basically I want CF to highlight the particular column all the cells. So if its March 19, I want that entire column to be red, and the rest stay white. But I want as little formulas as possible

Ok, so I've modified the formula to point to Mar-19, and I've also modified the Applies to =$C$4:$O$8, this is all the columns above all the way up to March 20. However, now March 20 also gets highlighted in a different colour like March 19 at the same time. If I change the time on my pc to april, it highlights april and drops march which is good. But when it sees March 19 and March 20, it matches them both for some reason?
 

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,395
Office Version
  1. 2016
Platform
  1. Windows
=month(c$4)&year(c$4)=month(today())&year(today())
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,626
Messages
5,838,438
Members
430,548
Latest member
hh_dh2001

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top