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

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

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

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