Macro to highlight rows based on workday dates

[Wedge120]

I need to run a macro on a spreadsheet daily that contains dates in column G.

If the date in this column matches today's date, highlight entire row color1. If it is one day before today's date, highlight rows color2. If it is tomorrow's date, highlight rows color3. I realize there are many ways this might be done, but my first approach went like this:

Please Login or Register  to view this content.

The problem with this is that Monday and Friday present a problem because Friday's date + 1 is Saturday; Monday's date - 1 is Sunday. The macro needs to include workday dates only, excluding weekend dates.
I am attaching an example of what I would like the result to look like, assuming today was 11/14/2014, and you can see the format of the date I must work with. It accounts for 11/13, 11/14, & 11/17 (skips weekend of 15th, 16th).

[nilem]

Hi Wedge120,

Try to use conditional formatting (see attachment)

[Demeter]

Hello Wedge120,

Did you have a look at the Weekday() function?
This will give you back a numeric value of the day in the week, by default 1 is sunday.

Following code must work (didn't test it):

Please Login or Register  to view this content.

Cheers,
Demeter

[Wedge120]

Demeter,

That works nicely, though your ELSEIF statements contain:

Please Login or Register  to view this content.

where they should be

Please Login or Register  to view this content.

Without this correction, the code doesn't work as expected.

[Wedge120]

Hi Wedge120,

Try to use conditional formatting (see attachment)

I figured there was a way to do this, but I don't quite follow what your doing. The language is Hebrew or something else?