Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Hours over budget showing in RED

Avatar

Level 3
Hi There: I've created a Task report that shows planned hours minus actual hours in a calculated field I have named Hours Remaining. I want to add some conditional formatting to the report so that all negative values (where actual hours is greater than planned hours) in that field are highlighted in RED. Anyone know the text mode for a revised view in the report that would show that?
Thanks! Bill Gattinger Contractor Mobile 780-717-6209 If you have received this email in error, please let me know by return email so I can make sure it doesn't happen again. Because emails can contain confidential and privileged material, I'd ask for your help by deleting it and any attachments. Thanks! We like to keep people up to date with information about new products and services at ATB or changes that could affect you. You can check out more about ATB and CASL at "http://www.atb.com/important-information/privacy-security/Pages/ATB-and-CASL.aspx" http://www.atb.com/important-information/privacy-security/Pages/ATB-and-CASL.aspx If you would like to unsubscribe from our updates, please use this URL - "http://www.atb.com/important-information/privacy-security/Pages/unsubscribe.aspx" http://www.atb.com/important-information/privacy-security/Pages/unsubscribe.aspx
1 Reply

Avatar

Employee Advisor
@Bill Gattinger If you have created a calculated field to capture this number, you will want to go ahead and add this field as a column to your Task Report. Click on the column header and then select Advanced Options in the top left. Add a column rule for this column so you can apply conditional formatting (highlighting). In your case, you will want it to look like the following: Task > Hours Remaining > Less Than > 0 Choose red as your background color then click, Add Rule. You can now save and close your report and for every row that has a negative number in the Hours Remaining column, it should be highlighted red. You will want to follow the same format of steps detailed in the article, Using Conditional Formatting in Views . If you have any questions, let me know! Nichole Vargas Workfront