# Conditional Formatting in "as List" view

**URL:** https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135
**Category:** DEVONthink
**Tags:** feature-request
**Created:** [July 11, 2024, 2:15pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135 "2024-07-11T14:15:16Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![MrSkooby](https://discourse.devontechnologies.com/letter_avatar_proxy/v4/letter/m/f05b48/32.png) [@MrSkooby](https://discourse.devontechnologies.com/u/MrSkooby)
#### Post date: [July 11, 2024, 2:15pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135/1 "2024-07-11T14:15:16Z")

</div>

Please consider this new feature request …

I always use the “as List” view in DTP. With a large(ish) screen and a small(ish) font quite a lot of records are visible at anyone time. However, sometimes I want specific records to stand out from the others. e.g. if modification date \> 90 days then set the cell background colour of the modification date to red. If custom data field value \> 66% then set the customer data field background colour to blue. There is a similar feature in Excel (and no, I’m not comparing DTP with Excel).

I appreciate there are some colour tags, flags etc but I’m already using these for other purposes but also don’t offer the conditional flexibility I’m after unless I start scripting for these as well.

Thanks for at least considering the suggestion.

MS

---

<div class="post-metadata">

### Author: ![cgrunenberg](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/cgrunenberg/32/7172_2.png) [@cgrunenberg](https://discourse.devontechnologies.com/u/cgrunenberg)
#### Post date: [July 11, 2024, 2:22pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135/2 "2024-07-11T14:22:54Z")

</div>

> [@MrSkooby](#):
>
> I appreciate there are some colour tags, flags etc but I’m already using these for other purposes but also don’t offer the conditional flexibility I’m after unless I start scripting for these as well.

You could use smart rules to automatically add/remove flags/tags/labels.

---

<div class="post-metadata">

### Author: ![BLUEFROG](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/bluefrog/32/135_2.png) [@BLUEFROG](https://discourse.devontechnologies.com/u/BLUEFROG)
#### Post date: [July 11, 2024, 2:31pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135/3 "2024-07-11T14:31:44Z")

</div>

While you may not be comparing DEVONthink directly with Excel, the interface isn’t built as a spreadsheet, so terms like _cells_ and _background color_ don’t apply. You need to work within the boundaries of the technology, so the available options are as @cgrunenberg noted: labels/tags/flag/ratings/custom metadata/etc.

---

<div class="post-metadata">

### Author: ![MrSkooby](https://discourse.devontechnologies.com/letter_avatar_proxy/v4/letter/m/f05b48/32.png) [@MrSkooby](https://discourse.devontechnologies.com/u/MrSkooby)
#### Post date: [July 11, 2024, 2:45pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135/4 "2024-07-11T14:45:44Z")

</div>

I accept that today I need to work within the boundaries of the technology and yes I can implement a second rate solution using smart rules etc.

But this was raised as feature request, something that potentially could extend the functionality of the product and _might_ appeal to many users. The feasibility of implementing it or the cost/benefit of doing so is obviously an internal discussion.

It was just a request/suggestion.

---

<div class="post-metadata">

### Author: ![BLUEFROG](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/bluefrog/32/135_2.png) [@BLUEFROG](https://discourse.devontechnologies.com/u/BLUEFROG)
#### Post date: [July 11, 2024, 3:04pm UTC](https://discourse.devontechnologies.com/t/conditional-formatting-in-as-list-view/80135/5 "2024-07-11T15:04:04Z")

</div>

Indeed and the request is noted 🙂
