Conditional formatting

Gaurav Chauhan

Hi Team,

When I run some formulae and they end up being invalid or such, I need to create a conditional format to highlight the cell in Red.

The condition is not reading "#" because its a formuale in there that doesnt populate the value

How do I do that

DandersonBluIP

I would try using a helper column with an If statement. such as =IF([Column4]@row > 5000, "red", " "), then apply the conditional format

Here's the sample I did. The helper column, in this example, column5 could be hidden.

Hope this helps.

Gareth Jeanes

Just a build on from @Danderson,

you could also use the iferror() function to output a different result, and then do conditional formatting for the colour.

https://help.smartsheet.com/function/iferror

Good luck.

Gareth