View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Simon Lloyd[_134_] Simon Lloyd[_134_] is offline
external usenet poster
 
Posts: 1
Default 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