CF Current Day

[ExcelRoy]

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

 

[Joe4]

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

=$B4=TODAY()

5. Choose your formatting option
6. Click OK

 

[ExcelRoy]

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]

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]

Hi Joe4

Sorry i meant row 2 not column 2

Thanks

 

[Joe4]

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:

=B2=TODAY()

 

[ExcelRoy]

Hi Joe4,

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

Thanks

 

[ExcelRoy]

edit:
=B$2=TODAY()

Thanks again

 

[Joe4]

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]

Hi Joe4,

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

I did highlight the complete range?

Thanks