coloring of cel lower then end time but higher then start time

T

teenbeat

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-$F6>TIMEVALUE("0:30")
can anyone help me
if nessecary i can send a exsample file
 
S

Simon Lloyd

Teenbeat, i'm confused your end time is before your start time? can yo
explain what you are trying to achieve

teenbeat;268589 said:
the thing is and that is my question when i have a starting time let
say i
cel B1 and a end time in cel A1. A1 is 0:00 and B1 is 0:3
when time in B1 gets lower then 0:30 but higher then 0:01 it has to ge
color re
but when they are both 0:00 nothing has to change accept standard ce
color
Also i have a already placed time value formula in it
=$D6-$F6>TIMEVALUE("0:30"
can anyone help m
if nessecary i can send a exsample fil

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
J

Jacob Skaria

Is possible. Please send the excel file..to (e-mail address removed)

If this post is helpful click Yes
 
S

Shane Devenshire

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$1>0,$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$1>0,$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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top