hello,
I am using sumproduct to calculate holiday requirments within a holiday planner, the sumproduct along with conditonal formatting, creates either a 0 for no holiday (CF rule 1 white cell) a 1 for holiday (CF rule 2 green cell) and a 2 for the weekends (CF rule 3 gray cell).
i need to add statutory holidays into the planner a different colour, however due to the constraints of CF, I already have 3 rules, so i need to change the sumproduct or to include holidays within the formula with either a vlookup or a match, but i'm unable to get it to work, the formula is as follows:
many thanks in advance
reg
Bookmarks