ExcelBanter - cond format time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cond format time (https://www.excelbanter.com/excel-worksheet-functions/214779-cond-format-time.html)

Dgwood90

cond format time

I have a spreadsheet that calculates battery run time. What I need is that
when the battery run time is down to 1/3, I would like the cell to turn red.
D2 is battery run time = 40 hours
D3 is remaining battery = 13
At 13.333 the cell should turn red.

T. Valko

cond format time

see your other post

--
Biff
Microsoft Excel MVP

"Dgwood90" wrote in message
...
I have a spreadsheet that calculates battery run time. What I need is that
when the battery run time is down to 1/3, I would like the cell to turn
red.
D2 is battery run time = 40 hours
D3 is remaining battery = 13
At 13.333 the cell should turn red.

All times are GMT +1. The time now is 08:14 AM.