Excel - Highlight current day

[andusbeckus]

Don't use excel much so not very familiar with it.

I need a way to highlight the column for the current day but the date isn't set out in the usual way as you can see from the image.

diary.jpg

[Glenn Kennedy]

Hi there... and welcome to the Excel Forum.

You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. Indeed dates can be a bit bothersome, so a picture is really useless. Not only that, but (depending on their choice of browser) many members cannot even see the image.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

[andusbeckus]

Hi there... and welcome to the Excel Forum.

You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. Indeed dates can be a bit bothersome, so a picture is really useless. Not only that, but (depending on their choice of browser) many members cannot even see the image.

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.

Thanks!

Hope this has worked then - http://www.excelforum.com/attachment...1&d=1471276252

[AliGW]

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

[andusbeckus]

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

For normal conversational replies, try using the QUICK REPLY box below.

Very helpful thanks!

[Glenn Kennedy]

OK. First go to B2 and enter the date 01/07/2016, drag across to 31/12/16. Format the cells in row B as d It will then look the same as it does now.

Use this formula for CF: =B$2=TODAY() and apply it to all cells.

Job done.

[andusbeckus]

OK. First go to B2 and enter the date 01/07/2016, drag across to 31/12/16. Format the cells in row B as d It will then look the same as it does now.

Use this formula for CF: =B$2=TODAY() and apply it to all cells.

Job done.

Excellent that worked great thank you!

[bebo021999]

The image can not make clear whether the days in row 2 is full date or not.
If, for example, DU2 is full date (11/1/2016) then the Conditional formatting formula should be:
=DU$2=today()
Copy formatting to all table.
If not, it is number 1 only, we have to concatenate it with the month year in row 1 to make full date.

[jason.b75]

Thanks for posting the sample file, it makes it easier for us to see what you are working with.

A couple of changes needed to make it work properly.

First change B2 from 1 to 1/7/2016 (needs a real date to work properly)

Next single click C2, then hold down shift + ctrl and press the right arrow key once (don't hold the arrow!). This should select the rest of the day numbers in the row.

Without scrolling, clicking, or moving anything, type =B2+1 then press Ctrl Enter, this will fill the rest of the dates in the row for you (please don't tell me you spent an hour typing them all individually )

At present you will not be able to see the dates, the cells will show ## because the dates are to long to fit. While the row is still selected simply change the format of the row to custom, and type a single d into the format box.

Next apply a conditional formatting rule (I see you already have some) to the range =$B:$GC

Using a formula as a rule, =B$2=TODAY()

Hopefully that will give you what is needed.

[Glenn Kennedy]

You're welcome!