View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
roster_jon[_2_] roster_jon[_2_] is offline
external usenet poster
 
Posts: 1
Default count resize range

Hey,

I need a VBA code that count the number of times "cf" occurs in the 14 cells
to the left of every cell, including the cell, in a range and change the
bottom border line to a thick red line if the count exceeds 4.

What I'm trying to do is point out if someone has been scheduled "cf" more
than 4 times in the past 14 days.

Is this possible at all?