change colors in a range of excel cells based on another range of cells
 

I would like to change the color of a cell in a range (A5:D50)if any
cell equals any cell in another range (V9:V20). All ranges are dates
and V9:V20 are not necessarily consecutive dates.

In addition that same set of cells A5:D50 would also be compared to a
second set of dates (V30:V35) and if any cell equals any date in this
second range. If so, the cell would change to a different color.

Any ideas?


Thanks,

Bobbi

*** Sent via Developersdex http://www.developersdex.com ***