Prev: How to reverse order on FOR loop?
Next: auto run a macro
From: Bobbi Muck on 8 Apr 2010 20:44

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 ***
 | 
Pages: 1
Prev: How to reverse order on FOR loop?
Next: auto run a macro