Conditional Formatting using the intersection of Two Values

Hi everybody,

I am currently working on a new spreadsheet and I would like to add conditional formatting to highlight today's date.

Simple enough, however, the date is split with the first row showing the days of 1 to 31(number format) and the first column shows the months Apr-16 to Mar-17(MMM-YY format) so would need to look up both of the values and then highlight the value where they meet.

I am using shading to highlight the weekends so looking for an alternative to highlight the date, possibly change the cell formatting so that it is highlighted with a red box.

Thank you,

S

PS - Please disregard the red box

When working with dates and times you must always post an example.



Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Sorry, I have now added a sample of the spreadsheet

Assuming that the instructions given in the file meant that you wanted L3 and M3, as opposed to L4, bordered in red, use the following CF rule (for the right side of the box) in addition to Jason's:

Formula:

Please Login or Register  to view this content.

Attached is a copy of your file with both rules applied.
Let me know if you have any questions.

You're welcome and thank you for the feedback. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. I hope that you have a good day.