Hi All,
im having a problem and would love for a little help. my situation is i would like Excel to fill the row with color if a duplicate entry but do nothing for a blank row until data has been entered.
I have an all data column ( =CONCATENATE([@[ Expiration Date]],[@NAME],[@COURSE],[@[TAKEN AT]]) )
then a ( =COUNTIF($G:$G,$G13)>1 applying to =$C$13:$F$707 )
but i dont want it to do anything for an empty cell.
thanks in advance
Bookmarks