cond format time

  • Thread starter Thread starter Dgwood90
  • Start date Start date
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

Back
Top