Turn font red if value is 80:00 or higher

Copper Contributor

What is the custom rule to turn font red in a cell if value in the cell is 80:00 or higher

3 Replies

@TheRealBCD 

Depending on how we're to read your 80:00, it could be this:

mathetes_1-1687882798032.png

 

Or this

mathetes_0-1687882703888.png

 

The 80:00 is 80 hours
[Red][>3.333333][h]:mm;[h]:mm
This worked. Thanks