I am working on a sheet that adds up time entries. I'd like the cell in which the total time appears to fill in red if the time exceeds 80 minutes (1:20:00). So in my example, the total appears in cell E20. I tried using conditional formatting to state that the fill would turn red if E20>1:20:00, but that didn't work. I tried several other options as well, but nothing has worked.
Bookmarks