Hello,

so I've never done this kind of formula and am not sure if it can even be formatted, it may have to be VBA... what I would like is this:

if column D5 rows 5-48 do nothave two entries of 2012 then highlight D4:G4 row 5.

I really hope that makes sense!