column A is my finished date, column C is my serial #. If I enter the same
serial # within 180 days of my finshed date what formula can I use to turn
cell red?

=A2<=C2+180

should do it

--

HTH

Bob

"hj" <(E-Mail Removed)> wrote in message
news140B3AF-8D8C-4559-8698-(E-Mail Removed)...
> column A is my finished date, column C is my serial #. If I enter the same
> serial # within 180 days of my finshed date what formula can I use to turn
> cell red?

Try this....

Select C2. In the conditional formatting dialog, add this formula:
=AND(LEN(A2)>0,LEN(C2)>0,SUMPRODUCT(--(C$1:C1=C2),--(A$1:A1>(A2-180))))
Select the formatting options to fill the cell with red when this formula
returns TRUE, then click OK. Use Format Painter to copy this conditional
formatting to all of column C.

Hope this helps,

Hutch

"hj" wrote:

> column A is my finished date, column C is my serial #. If I enter the same
> serial # within 180 days of my finshed date what formula can I use to turn
> cell red?

I've been waiting over 2 days to try and help, hope this does:
in cell c2 Use Conditional Formatting and "Cell Formula is" and enter
=SUMPRODUCT(--(A$1:A1>A2-180),--(C$1:C1=C2))
you can use the format painter to 'fill' this on up/down that column. I
think it'll do the trick, if not, then Tom Hutchins' solution may be the one.


"hj" wrote:

> column A is my finished date, column C is my serial #. If I enter the same
> serial # within 180 days of my finshed date what formula can I use to turn
> cell red?