Highlight Cells Tomorrow Excluding Weekend

Here!

Assuming your data in in cell C1, try this -

=C1=IF(WEEKDAY(TODAY(),1)=1,TODAY()+1,IF(WEEKDAY(TODAY(),1)=7,TODAY()+2))

Change the CF range as required.

Hey There,

You can use the following function to do conditional formatting if tomorrow is not Saturday or Sunday.

=IF(TODAY()+1=WORKDAY(C1,0,2),TODAY()+1,"")

Yes, It will cover the entire column but will only highlight the tomorrow's date if tomorrow is weekdays.

I hope this is what you were looking for.

Hi...You just need to change the date and put it in conditional formatting.

Go to Cell C6 and and open Conditional Formatting window and follow the below steps

1. Your cursor should be on C6
2. Go to Home-->Styles-->Conditional Formatting-->Highlight Cell Rules-->More Rules-->Use a Formula to determine which cells to format
3. Type the following formula - "=IF(TODAY()+1=WORKDAY(C6,0,2),TODAY()+1,"")"
4. Click on Okay -->Apply
5. Copy C6 and drag it to the last cell of C column where date exists.


It will highlight only tomorrow's date if tomorrow's is not Saturday or Sunday.

I am also attaching a workbook for your reference. Please see the attachmnet.

Your file is password protected and I have given exactly the same which you are looking for here.

Let me explain you what function is doing.

=IF(TODAY()+1=WORKDAY(C6,0,2),TODAY()+1,"")

So the If condition, If Tomorrow (Today is 13th and tomorrow is 14th Apr) is equal to Workday (Which will be from Monday to Friday) then it will highlight the cell containing date of 14th April'15 else it will not highlight anything and leave it as blank.

I hope it is very simple what you just need to do is copy the same function and paste it in your file in conditional formatting.

Cheers!!!
Anil Dhawan

I hope it will work!!!



Kindly take few seconds to mark this thread as SOLVED and *Add Reputation if I helped you.

Originally Posted by adhawan06

You can use the following function to do conditional formatting if tomorrow is not Saturday or Sunday.

=IF(TODAY()+1=WORKDAY(C1,0,2),TODAY()+1,"")

But doesn't this need to work if tomorrow is a Saturday? In that case it needs to highlight the Monday.

You simply want to format C6 if it's equal to the following working day, which you can do like this:

=C6=WORKDAY(TODAY(),1)

Originally Posted by daddylonglegs

But doesn't this need to work if tomorrow is a Saturday? In that case it needs to highlight the Monday.

You simply want to format C6 if it's equal to the following working day, which you can do like this:

=C6=WORKDAY(TODAY(),1)

Hi, As user wants if tomorrow is Weekend (Saturday or Sunday) then it should not be highlighted and if the next working day is Monday, It should not highlighted until Sunday So it should be highlighted once i reach on Sunday.

Originally Posted by d3fcon

ok getting there and looking good. have a look at this and see if you can follow. The macro creates a new line on send etc.
The usual setting today / tomorrow and yesterday (basic ones ) work fine. The dates highlight accordingly. you could image if i had a due date of the 13th
of April on there it would nit highlight the cell until the 12th (Sunday)

Hi d3fcon,

I too have a similar question & when I test the formulas provided by experts I find them not working.
I checked the question by OP from post# 6 on-wards.

The file is attached.

Note: The formula use Today function. To test the formulas you need to change the System Dates.

Regards,
AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread