CF Current Day

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows
Hi,

I am looking to highlight the current day in a calendar planner

I have the dates in column 2 and would like the range 4:15003 highlighted when the todays date is the same as the corresponding date in row 2

Also using the same method highlights when row 3 is a "Sa" Saturday and "Su" Sunday using the same range

Many thanks for any help
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
OK, so if you want to perform Conditional Formatting on the range B4:B15003, to highlight any cells equal to today's date, do the following:
1. Select range B4:B15003
2. Click on Conditional Formatting
3. Choose the "Use a formula to determine which cells to format" option
4. Enter the formula
Excel Formula:
=$B4=TODAY()
5. Choose your formatting option
6. Click OK
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows
Hi Joe,

Thanks for the reply

I have K2 is 31/07/20, L2 is 01/08/20, M2 is 02/08/20 etc

I am not sure this method will work this way?

Thanks
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
I have K2 is 31/07/20, L2 is 01/08/20, M2 is 02/08/20 etc

I am not sure this method will work this way?
I thought you said your dates were in column 2?
How exactly is your data structured?
What cells do you want checked for today's date?

If you are having troubles explaining it, maybe post a small example of what your data looks like and exactly what you want to happen.
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Hi Joe4

Sorry i meant row 2 not column 2

Thanks
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
Sorry i meant row 2 not column 2
It should essentially work the same way.
You just select the entire range that you want to apply it to, and enter the formula as it pertains to the first cell in that range. As long as you don't lock the range down with absolute range references, Excel will automatically adjust it for all the other cells in that range.

So, if cell B2 was the first cell in your selected range, you would just use the Conditional Formatting formula:
Excel Formula:
=B2=TODAY()
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows

ADVERTISEMENT

Hi Joe4,

Thanks, almost works, only highlights first row of the range?

Thanks
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows
edit:
=B$2=TODAY()

Thanks again
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,913
Office Version
  1. 365
Platform
  1. Windows
Thanks, almost works, only highlights first row of the range?
edit:
=B$2=TODAY()

Thanks again
I am a little unclear if you are saying you have it working now or not.
If not, and that is your formula, putting the "$" in front of the 2 locks it down to row 2, so that would be the only row that ever can be highlighted.
Remove the "$" to allow the rows to "float" and it will work for the other rows.
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,450
Office Version
  1. 2007
Platform
  1. Windows
Hi Joe4,

Yes thanks all working fine now, although it does work with $ in the formula

I did highlight the complete range?

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,576
Members
413,996
Latest member
mabelO

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