wizard4all
New Member
- Joined
- Mar 10, 2006
- Messages
- 3
Hello,
I would like to use vb to fill a cell with color when the intersection of multiple ranges matches, all being dates. Example, lookup range A1:B4 and B1:B4 for matches in C1:F1. If A is empty then it would still look to fill the one B date match.
http://imgur.com/2cpZD
I know I can do this with conditional formatting but i am unable to overwrite the color in that case. I will be loading a sheet with multiple dates and would like to just run a macro due to the volume of data I have and the need to overwrite after the initial macro run.
Appreciate any help!
Thank you!!
I would like to use vb to fill a cell with color when the intersection of multiple ranges matches, all being dates. Example, lookup range A1:B4 and B1:B4 for matches in C1:F1. If A is empty then it would still look to fill the one B date match.
http://imgur.com/2cpZD
I know I can do this with conditional formatting but i am unable to overwrite the color in that case. I will be loading a sheet with multiple dates and would like to just run a macro due to the volume of data I have and the need to overwrite after the initial macro run.
Appreciate any help!
Thank you!!