View Single Post
  #5   Report Post  
Old February 8th 06, 03:17 PM posted to microsoft.public.excel.newusers
Dri
 
Posts: n/a
Default Change cell colour by date

Max,
Thanks for taking the time out to help me. You've pointed me in the right
direction perfectly.
Best wishes

"Max" wrote:

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
---