conditional format help

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" wrote in message
news
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:A1A2-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?