Need help with conditional formatting formula

[smurphy619]

Hi everyone,

I have a decently working code right now that takes data which is output from a program and input into excel. I have almost every step of the macro working as I need it to, however one step is tripping me up a bit. I am trying to highlight any rows which contain a Due Date which is past due (so any late jobs) in Red, any jobs that are due today in blue, any due in the next two days as green, and any in the future as purple. So far, I am able to color the cells easily enough for past due and future, however jobs due today is tripping me up a bit. It seems that, even though I had excel format the cells as only dd/mm/yyyy, there is still time stamp data being considered for the formula, so now all jobs with a due date of 4/29/14 are being counted as due today (or something like that.)

So far I've been using the conditional format for =$G2-.1<TODAY() and making that turn the row red, and so on.

I have only just started to teach myself to program so I'm sure that I am working at it in a clunky way, but I'm just trying to define it for the worksheet that if any date's listed are past today's physical date (by that I mean just the day number that it is) it switches.

I also don't know how to write a conditional format for if a value lands inside a range; for example, if I want to change the color of all cells with due dates encompassing both today and tomorrow. Thanks for any help you can give.

Sean

- I do have the entire code that I'm using available if that helps