Thread: color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
teenbeat teenbeat is offline
external usenet poster
 
Posts: 4
Default color

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