View Single Post
  #2   Report Post  
Ray A
 
Posts: n/a
Default


One way
Select entire row. FormatConditional Formatingformula is
=IF(COUNTIF(2:2,A2)1,TRUE,FALSE) <select formating
HTH
ray

"George" wrote:

On my spread sheet column "A" is student names - Column "B" - "C" - "D" - "E"
- "F"
are the the class dates they are assigned training.

Is there a conditional format that I could use that would color the
background of
any date thats a duplicate - By Row ?

Ex: If row 9 - I scheduled someone for training 14 Aug, 25 Aug, 31 Aug, 14
Aug, 01 Sep - This should flag the 14 Aug as a duplicate entry.

Thanks - George