cell flags red four working days before date in cell

Originally Posted by bmmerkx

I'd suggest to apply Conditional Formatting to the date-cell:

- Select Cell
- Home-tab, Conditional Formatting, Highlight Cells Rules, Equal To
- Criteria:

Please Login or Register  to view this content.

(which is not in working days, but you could add an IF criteria as well if needed)

Not sure what you mean by an IF criteria???

The conditional formatting I use now looks like this =I12<TODAY() but this only flags up once the cells date passes todays date which is usually to late. I need it to warn me four days before hand (preferably working days cause i know excel does recognise them)

Thankyou

So, use my code.

Could you please specify which are the non-working days? Sat and Sun? Any holidays?

Originally Posted by bmmerkx

So, use my code.

Code is good thats working great now!!!!!!!!!

But any one know how to do the working days part. Non-working days being Sat/Sun and any bank holidays (but not worried about the bank holidays if that is too differcult)

Thank you everyone

Hoildays are no problem but I have no idea which they are. I suppose you could set them up somewhere

Originally Posted by arthurbr

Hoildays are no problem but I have no idea which they are. I suppose you could set them up somewhere

Ok, well to be honest not really worried about the holiday part could you just help me with excluding the weekends.

Thanks

Originally Posted by DonkeyOte

If you are using XL2007 you can use NETWORKDAYS in the Conditional Format formula (pre XL2007 you can not) - see XL help for more info.

I'm using 2007. What I really need is someone to edit this formula to only include the working days

What I have so far :
=I12<TODAY()-4

Thanks

Please have a look at the NETWORKDAYS syntax