Conditional Formatting Last working day of month

[PCCS13]

I need to add a formula which determines if the following (in column J):

If F2 is empty, colour J2 cell red.
If date in J2 is earlier than the last day of this month, colour J2 red.
If cell J2 is empty - colour J2 red.

The formula would then be applied for the whole of column J

 

[Jonmo1]

This will give you the last working day of the current month.

=OR(F2="",J2="",J2 < WORKDAY(EOMONTH(TODAY(),0)+1,-1,Z1:Z20))

This requires the analysis toolpack from Tools - Addins.
Z1:Z20 is an OPTIONAL range of Holiday Dates that should be considered NON working days.

Unfortunately, you can't use this function in conditonal formatting (at least not in XL2003)
So you'll have to put that formula in it's own cell, say G2 for example.
Then in conditional formatting use
=OR($F2="",$J2="',$J2<$G$2)