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

  • Thread starter Thread starter teenbeat
  • Start date Start date
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
 
Is possible. Please send the excel file..to (e-mail address removed)

If this post is helpful click Yes
 
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.
 
Back
Top