Condition formatting - Priorities

Ed Gadd

I'd like to add condition formatting to cells on a sheet which show items in the next 7 days as one color. And Items in the future as another. Unfortunately the higher priority format ( in the future) cancels the (in the next 7 days) is there a way to make this work please?

Thanks in advance

SoS | Dan Palenchar

Hello @Ed Gadd.

Conditional formatting rules kick in based on the order they appear with the top rules taking precedence over later rules. If you reverse the order of your rules you should be fine so that you have:

1. Show rows with items in the next 7 days as a certain color
2. Show rows in the future as another color

This video might help you learn more about how to use conditional formatting.

https://www.youtube.com/watch?v=UOjtJkTQU4Y

SoS | Dan Palenchar

Hello @Ed Gadd.

Conditional formatting rules kick in based on the order they appear with the top rules taking precedence over later rules. If you reverse the order of your rules you should be fine so that you have:

1. Show rows with items in the next 7 days as a certain color
2. Show rows in the future as another color

This video might help you learn more about how to use conditional formatting.

https://www.youtube.com/watch?v=UOjtJkTQU4Y

Ed Gadd

@SoS | Dan Palenchar Many thanks. I should have expected Smartsheet's to have this set up as an easy arrangement. Thanks again

SoS | Dan Palenchar

@Ed Gadd happy to help!