Posted to microsoft.public.excel.misc

Dgwood90

external usenet poster

Posts: 22

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting and time	mndpy	Excel Worksheet Functions	1	September 4th 07 07:46 PM
conditional formatting using clock time	Merna	Excel Worksheet Functions	5	March 1st 07 08:01 PM
Conditional Formatting with Date and time	Dom	Excel Discussion (Misc queries)	14	February 20th 07 12:43 PM
conditional formatting & time stamp	Alib	Excel Discussion (Misc queries)	2	December 29th 05 08:07 PM
conditional formatting with time values	Access Idiot	Excel Discussion (Misc queries)	2	September 13th 05 03:29 PM

All times are GMT +1. The time now is 08:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us