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...
Yes. Use conditional formatting rules.
the first option is based on value, the sub-menu the second option is then <
it then prompts with what value and you can try 40:00 but you may need to convert that to a value. is that 40 hours or 40 mins? I would use =40/24 for hours and =40/24/60 for mins.