https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120637.aspxMon, 18 Mar 2019 20:23:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120637spiderkzn0https://www.infopathdev.com:443/forums/thread/120637.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120637You are a star!!!!!https://www.infopathdev.com:443/forums/thread/120636.aspxMon, 18 Mar 2019 19:31:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120636Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120636.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120636See attached. Save the file locally, right click and select design. Then preview. There is one table with a bunch of years filled out and the same table below with conditional formatting rules on it.https://www.infopathdev.com:443/forums/thread/120634.aspxMon, 18 Mar 2019 17:02:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120634spiderkzn0https://www.infopathdev.com:443/forums/thread/120634.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120634That right. How do i make conditional formatting rule? if you can guide me to step by step? like formula something?https://www.infopathdev.com:443/forums/thread/120633.aspxMon, 18 Mar 2019 16:53:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120633Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120633.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120633Got it - you want to set a filter on the repeating table to only display items where the year is between those values. So - add a conditional formatting rule to your repeating table with the condition that the Year column is greater than or equal to 2016 AND that the Year column is less than or equal to 2019. :-)https://www.infopathdev.com:443/forums/thread/120632.aspxMon, 18 Mar 2019 15:34:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120632spiderkzn0https://www.infopathdev.com:443/forums/thread/120632.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120632Hi Hilary, sorry for not making it clear. Ok here the repeating table for example when I run like eg See image link https://i.ibb.co/dB6GsJg/wefwef.png I hope it clear?https://www.infopathdev.com:443/forums/thread/120631.aspxMon, 18 Mar 2019 15:18:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120631Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120631.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120631Do you mean that the value in the column should look like "2016-2019" or that the value should be anything from 2016 up to and including 2019? Or something else that I'm not understanding? :-)https://www.infopathdev.com:443/forums/thread/120630.aspxMon, 18 Mar 2019 15:12:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120630spiderkzn0https://www.infopathdev.com:443/forums/thread/120630.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120630Hi, I'm looking for a way to display repeating table with Year on column that must show range of year for 2016-2019. I tried use formulas as it look like only accept return one value, can it possible to show more than year value?