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