# Highlight Cells Tomorrow Excluding Weekend

1. ## Highlight Cells Tomorrow Excluding Weekend

I have dates entered manually down the C column and i use the standard highlight rule to color the cells i.e Today. Tomorrow and Yesterday. Now my issue is come Friday in the week i wish to have Mondays date highlighted as Tomorrow so it has excluded the weekend. The standard conditional formatting for when date occurs wont work in this instance and i have tried at least 20 formulas from forums etc.

What am i doing wrong ? or is there a simpler way? I just wish it to not count any weekends and make Friday 1 and and Monday the day after so it will highlight as if it was tomorrow

2. ## Re: 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.

3. ## Re: Highlight Cells Tomorrow Excluding Weekend

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,"")

4. ## Re: Highlight Cells Tomorrow Excluding Weekend

Will this cover the complete C column ?

Example

DATE REQUIRED
16-Apr
20-Apr
18-May
11-May
07-May
04-May
01-May
07-Jul
16-Apr
03-May
06-May
17-Apr
24-Apr
20-Apr
11-May
14-May
19-Apr
20-Apr

5. ## Re: Highlight Cells Tomorrow Excluding Weekend

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.

6. ## Re: Highlight Cells Tomorrow Excluding Weekend

o.k sorry i really need to explain my self a little better. that dates run from C6 Down and i need it to highlight only the ones for tomorrow's date but of coarse excluding any weekends. I.e Friday 12th and the next date that would need to highlight for tomorrow would be Monday the 15th.

I really appreciate your help guys it's been doing my head in hahah

7. ## Re: Highlight Cells Tomorrow Excluding Weekend

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.

8. ## Re: Highlight Cells Tomorrow Excluding Weekend

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

9. ## Re: Highlight Cells Tomorrow Excluding Weekend

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)

10. ## Re: Highlight Cells Tomorrow Excluding Weekend

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

11. ## Re: Highlight Cells Tomorrow Excluding Weekend

Thank You ill give it a run

12. ## Re: Highlight Cells Tomorrow Excluding Weekend

I hope it will work!!!

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

13. ## Re: Highlight Cells Tomorrow Excluding Weekend

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)

14. ## Re: Highlight Cells Tomorrow Excluding Weekend

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)

15. ## Re: Highlight Cells Tomorrow Excluding Weekend

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

16. ## Re: Highlight Cells Tomorrow Excluding Weekend

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)
YES! THANK YOU! I've been searching for this formula for almost two hours. All I want is to highlight the next business day, I knew it didn't need to be something complicated, only something I wasn't thinking of. THANK YOU!!!

17. ## Re: Highlight Cells Tomorrow Excluding Weekend

Hi...still not figure out how it works...could you please share your excel for reference?

18. ## Re: Highlight Cells Tomorrow Excluding Weekend

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.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.09455 seconds
• Memory Usage 9,380KB
• Queries Executed 16 (?)
Template Usage (35):
• (4)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (18)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (3)postbit_attachment
• (18)postbit_legacy
• (18)postbit_onlinestatus
• (18)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (49):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• postbit_attachment
• tag_fetchbit_complete