View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dgwood90 Dgwood90 is offline
external usenet poster
 
Posts: 22
Default 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.