Thread: Count macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nbhp nbhp is offline
external usenet poster
 
Posts: 1
Default Count macro

I have 2 columns of data (A3:A100 and H3:H100) and wish to count the number
of non-blank cells in each range, then compare the totals. If the totals are
equal then the tab for the worksheet will change colour, say red. I have not
really used the count function before and all attempts so far have failed.

Anyones help would be greatly appreciated.

Many Thanks