Color entire range on conditions

[mso3]

Hello friends,

I want to color the entire range on following conditions.

Column ‘P’ contains ‘Birthdates’
If there is a birthday today then the entire range should color violet

Column ‘Q’ contains ‘Marriage anniversary date’
If there is a marriage anniversary today then the entire range should color pink.

If there is a birthday and marriage anniversary both today then the entire range should color green

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

[mso3]

Hi friends,

Here is a workbook attached for your reference.

Thank you,

[humdingaling]

Please Login or Register  to view this content.

instead of creating 3 loops just create one with conditions within that loop
i choose to use 2 boolean as markers this time
just seemed easier to map out

[mso3]

Hi humdingaling,

Excellent! Nice approach.

Thank you and have a nice day.

[mso3]

Hi humdingaling,

The code is working fine but after inserting it in my original workbook I’m getting run-time error 13 type mismatch.

I inserted the code in my original workbook and getting run time error 13 type mismatch on the following line

Please Login or Register  to view this content.

The code is:

Please Login or Register  to view this content.

Thank you.

[humdingaling]

Please Login or Register  to view this content.

make this nested instead...that way if it is blank or not a date it just skips

Please Login or Register  to view this content.

replicate for marriage check as well

if this still doesnt work....check what value "I" is
maybe the last row method i used in the FOR loop is picking up too many rows

[mso3]

Hi humdingaling,
Perfect! Now it's working fine.

Thank you and have a nice day.