Conditional Formating
 

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

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