I have a PM who wants to highlight text for last update date yellow if the date is between 7 and 30 days ago, red if greater than 30. This sounds simple enough, but it WILL NOT WORK! I can get one rule or the other working, but when I have two rules together (the order doesn't seem to matter) only one of them works. Below is the current code I have, only the first rule (red, bold >30 days ago) is working. It was the only rule that worked even when the second rule was first in the code. Any ideas?? linkedname=direct namekey=lastUpdateDate querysort=lastUpdateDate styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=lastUpdateDate styledef.case.0.comparison.lefttext=lastUpdateDate styledef.case.0.comparison.operator=lt styledef.case.0.comparison.operatortype=date styledef.case.0.comparison.righttext=$$TODAY-31D styledef.case.0.comparison.trueproperty.0.name=fontstyle styledef.case.0.comparison.trueproperty.0.value=bold styledef.case.0.comparison.trueproperty.1.name=textcolor styledef.case.0.comparison.trueproperty.1.value=d30519 styledef.case.0.comparison.truetext= styledef.case.1.comparison.icon=false styledef.case.1.comparison.leftmethod=lastUpdateDate styledef.case.1.comparison.lefttext=lastUpdateDate styledef.case.1.comparison.operator=between styledef.case.1.comparison.operatortype=date styledef.case.1.comparison.righttext=$$TODAY-7D styledef.case.1.comparison.righttextrange=$$TODAY-30D styledef.case.1.comparison.trueproperty.0.name=textcolor styledef.case.1.comparison.trueproperty.0.value=e19503 styledef.case.1.comparison.truetext= textmode=false valuefield=lastUpdateDate valueformat=HTML Alison Wells Community Medical Centers
