Thread: colouring cells that are between two dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian[_13_] Ian[_13_] is offline
external usenet poster
  
Posts: 8
Default colouring cells that are between two dates
On Tue, 6 Sep 2005 15:32:47 -0400, "Tom Ogilvy"
wrote:

If ((cell.Value = Range("B9").Value) And (cell.Value <
Range("B10").Value)) And (IsDate(cell.Value)) Then
cell.Interior.ColorIndex = 4


Thanks Tom, as ever you have the solution. I nearly got there
but but got confused with using the datevalue.

Thanks again,

Ian,
Reply With QuoteReply With Quote