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

  • Thread starter Thread starter Bobbi Muck
  • Start date Start date
B

Bobbi Muck

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
 
Bobbi

Try apply these two formula to conditional formattin
=SUMPRODUCT(--(A5=$V$30:$V$35))>0 (set red colour) and =SUMPRODUCT(--(A5=$V$9:$V$20))>0 (set blue colour) to cell A5. Then copy the cell A5 and paste special, format to other cell A5:D50

Lee Li Fon
Blog: http://smartusemicrosoftoffice.blogspot.com/
 
Back
Top