Conditional Formating

[George]

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

[Ray A]

One way
Select entire row. Format>Conditional Formating>formula 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