View Single Post
  #4   Report Post  
Old February 8th 06, 12:16 PM posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default Change cell colour by date

Select row2 down to row10 (select the row headers)

Just a clarification that we could actually select rows beyond row10, i.e.
pre-format ahead of dates input in col B, since the CF formula includes
checks for blank cells in col B as well (via the part: $B2<"").
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---