Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring of cel lower then end time but higher then start time
the thing is and that is my question when i have a starting time lets say in
cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring of cel lower then end time but higher then start time
Teenbeat, i'm confused your end time is before your start time? can you explain what you are trying to achieve? teenbeat;268589 Wrote: the thing is and that is my question when i have a starting time lets say in cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74947 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring of cel lower then end time but higher then start time
Is possible. Please send the excel file..to
If this post is helpful click Yes --------------- Jacob Skaria |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
coloring of cel lower then end time but higher then start time
Hi,
To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (B1 in your case) 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =AND($B$10,$B$1<3/144) 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =AND($B$10,$B$1<3/144) 5. Click the Format button and choose a format. 6. Click OK twice 3/144 is the equivalent of TIMEVALUE("3:30") If this helps, please click the Yes button. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "teenbeat" wrote: the thing is and that is my question when i have a starting time lets say in cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:30 when time in B1 gets lower then 0:30 but higher then 0:01 it has to get color red but when they are both 0:00 nothing has to change accept standard cel colors Also i have a already placed time value formula in it : =$D6-$F6TIMEVALUE("0:30") can anyone help me if nessecary i can send a exsample file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |