cond format time

D

Dgwood90

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top