If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
conditional format help
=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? |
#3
|
|||
|
|||
conditional format help
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? |
#4
|
|||
|
|||
conditional format help
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? |
Thread Tools | |
Display Modes | |
|
|