conditional format help

[hj]

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?

 

[Bob Phillips]

=A2<=C2+180

should do it

 

[Tom Hutchins]

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

 

[JLatham]

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.