{"id":2959,"date":"2016-12-27T17:36:27","date_gmt":"2016-12-27T14:36:27","guid":{"rendered":"https:\/\/everhour.com\/blog\/?p=2959"},"modified":"2023-04-11T17:02:51","modified_gmt":"2023-04-11T14:02:51","slug":"conditional-formatting","status":"publish","type":"post","link":"https:\/\/everhour.com\/blog\/conditional-formatting\/","title":{"rendered":"Conditional Formatting in Reports"},"content":{"rendered":"

Merriest Christmas and a Happy New Year!<\/p>\n

In this last week of the year, we are pleased to present another cool feature that enhances your reports. It is called conditional formatting.<\/p>\n

Conditional formatting allows you to highlight various pieces of data in individual cells of your reports. This can help you see patterns or invalid values that might be hard to spot otherwise.<\/p>\n

\"conditional<\/a><\/p>\n

<\/p>\n

How can I use it?<\/p>\n

Say I am an admin and am looking through a long monthly timesheet report.<\/p>\n

Sometimes in a hurry, it is difficult to notice slight variations in time. So now I can highlight days where the reported time is less than usual. For example, highlight with yellow everything that is less than 6 hrs and uses red for values under 2 hrs.<\/p>\n

To do so, I open up my report options > choose formatting tab > set the desired criteria<\/p>\n

\"conditional<\/a><\/p>\n

In the same way, I can identify tasks where the reported time is close to an estimate, allocate tasks with the time above a certain threshold, or find overtimes.<\/p>\n

You can add multiple conditional formatting rules.<\/p>\n

Once a rule\u2019s criteria are met, the corresponding format is applied. In the case of conflicting rules, the last one is always applied, so you can increase or decrease the priority of a rule keeping in mind its order.<\/p>\n

If there are any questions or ideas, just drop us a line at ask@everhour.com<\/a>.<\/p>\n\n\n