| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cond format time
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding / Cond. Format | Excel Discussion (Misc queries) | |||
| Cond format with date | Excel Worksheet Functions | |||
| Whole Row Cond. Format | Excel Discussion (Misc queries) | |||
| Cond format more than 3 colours | Excel Discussion (Misc queries) | |||
| cond format | Excel Worksheet Functions | |||
Linear Mode
