conditional formatting, bleh
trying to use this formula for conditional formatting in column D:
=NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE)))
where any value in D that is found in SLS_Holidays will be highlighted. It wont accept copy/paste, and attempts at modifying it are not getting me anywhere. please help.
|