conditional formatting time
I have a spreadsheet that calculates remaining battery time. What I am
wanting is when battery run time has less than 1/3 remaining I want that cell
to turn red.
For example:
D2 has battery run time: 40 hours
D3 is remaining battery life: 13 hours
So when D3 drops below 13.333 hours it will turn red.
|