Forum Discussion
Formatting cell to change font color based on a broken rule
I'll be as specific as possible. I want to format a cell so that IF say cell A1 has a value less than 40:00, the font color is red. 40:00 or higher is black. Also the value displayed in cell A1 comes...
Thank you . That works just as I wanted.
What is the formula for 24:00 in the same scenario?
What is the formula for 24:00 in the same scenario?
I used 1.66666666666 because 40 hours = 40/24 day = 1.6666666666666
24 hours = 1 day, so use 1 instead of 1.66666666666
- Awesome, Thanks!