Create Macro to execute multiple Conditional Formatting Formulas

[lashellr]

Trying to create a macro that hightlights and/or fills a row based on certain criteria
i.e. If the date (in column I) is older than today, change the font to red
If the date (in column I) is with the next 10 days, change the font to purple
If Column G has "3" or "1" OR there's a "0" in Column J, then highlight the background mint green.

However, it is no working properly. It's like the VBA thinks there's a conditional applied to a cell to it'll over look some of the rows. Other rows, like the header has conditions apply when it meets none of the criteria. I honestly can't explain what it's doing. Here's a sample.

HelpMe2.xlsm

Here's the code

Please Login or Register  to view this content.

[judgeh59]

a few questions

there are no Dates in column "M"....which column (D or I) did you mean.

you aren't choosing a RANGE at the beginning of the macro...did you mean to?

I added a clearing of the CF at the beginning of the macro and a RANGE at the begininng of the macro....not sure I'm helping...

Please Login or Register  to view this content.

[lashellr]

Sooo, sorry. I meant column 'I' and I guess my range would be the whole spreadsheet Column A to M. Maybe that's why my macro isn't formatting properly? I'm not sure. Yet, i really apprecaite any help that comes my way.

[judgeh59]

Hey, type perfect and never make mistakes......yeah.....right.....thanks...I take it the updates I did, didn't help?

[lashellr]

Not really, but it was closer than I was.

[judgeh59]

how about this... it suffered from what we used to call an "Off by one error"....I actually start on row 1 even though your "data" starts on row 2....I think this works....

Please Login or Register  to view this content.

[lashellr]

TYTYTYTY!!!! It finally works. You are awesome sauce.

[judgeh59]

I'm glad I could help....

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

[lashellr]

Solved and rep'd!

[judgeh59]

thanks.....my Mom and the moderators will be happy....have a great day....