InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:09:38 GMT20http://www.sqlservercentral.com/Forums/Topic1396623-1497-1.aspxHiI have an SSRS report that I want to use conditional formatting, but I'm not sure that what I want to do is possible, I have not been able to find a solution on forums yet.I have a table with columns "Servername", "PageLifeExpectancy". I want to use conditional formatting to hightlight the "Page Life Expectancy" value according to the "ServerName".Thus, If the "Servername"='Server1' AND the "PageLifeExpectancy"<1400 then "PageLifeExpectancy" colour should be REDIf the "Servername"='Server1' AND the "PageLifeExpectancy">1400 then "PageLifeExpectancy" colour should be GREENIf the "Servername"='Server2' AND the "PageLifeExpectancy"<300 then "PageLifeExpectancy" colour should be REDIf the "Servername"='Server2' AND the "PageLifeExpectancy"<300 then "PageLifeExpectancy" colour should be GREENI hope someone can help me to set this up as I really do not want to create this report in Excel. :-)Thx,TheresaFri, 14 Dec 2012 06:44:34 GMTTDP