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.