Cond. format if date is within 10 days of any other date in same column

[Nicky D.]

My challenge:
Identify potential resource/date conflicts within a column (range) of dates.
I have a limited number of resources available to perform some work on a
number of projects.
If (for example) 'dig ditch' occurred at the same time on multiple projects,
I would like to highlight all of the conflicting dates.
It would be easier for me to use conditional formatting, so that I could
copy/paste among a number of sheets. However, any solution (less portable)
is of interest.
Although, it may not influence the solution, I would have multiple columns
of dates (dig ditch, bake cake, test code, etc..)
Thanks,
Nicky D.

 

[Frank Kabel]

Hi
you may provide some details which cells you exactly want to compare.
You could then do this within the conditional format dialog after
choosing 'formula'

 

[Nicky D.]

Frank,
Thank you for responding.
Let me see if I can clarify my question.
I have a column of dates - let's say A2:A20. They would be in random order
(A2 = 10/19/05, A3 = 1/1/02, A4 = 10/25/04, A5 = 1/8/02, etc.).
I want to identify (E.g., Turn a date to Red text using conditional
formatting) two or more dates that fall within 10 days of each other.
I think this would also apply to any column of numbers: If my column was 1,
40, 100, 9, 37, 88; then 1, 9, 40, & 37 would be in red because each of
those are within '10' of at least one other number in the column/range.

So, I think the statement would be something like:
If AbsoluteValue(this cell - ((any value in A2:A2) but not this cell) <=10,
TRUE {red}, FALSE {do nothing}

I don't know how to cycle through the range (A2:A22), and I'm not sure how
to exclude the current cell.

Any direction is appreciated.