Re: select by data validation list to highlight the cells
thanks for the reply... i updated my sheet has little more to understand the problems u try to enter the dates in column "c & d" and choose the leave type in column "E" LOOK only in January month the leave type is not chaining to what i choose in column "E" with multiple entries of employee in same month.
ok actually if i enter the INPUT selection in column "A ,B,C,D,E" once i enter the date IN COLUMN "C & D" then the calender in January month it will update the leave type has a color what i choose in column "E" ( the color i explained in column "AR16:AS18") eg:- if i select 1) it represents has annual leave 4) represents has in-lue 5) represents has sick leave.
i enter the formula in month of january calender month has =SUMPRODUCT(($G7=SNames)*(SFrom<=H$5)*(STo>=H$5))*$F7
but problem has if i select the employee 01 he taking has two type leave in January has a (from 2-jan-17 to 13-jan-17 has in-lue) and (from 15-jan -2017 to 22-jan-17 has annual leave) but showing color has blue instead of green color.
i need to correct the formula in "= sumproduct " if i enter the choose the leave type in column "E" i need has same color in the January month.