View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jen_T Jen_T is offline
external usenet poster
 
Posts: 66
Default conditional format macro

I have a spreadsheet that coworkers will need to delete and add data daily
that I will need to audit to ensure specific columns such as zip codes,
account #'s have specific number of digits. Is there macro that I can use
that will loop through all the data and highlight each column that does not
have the specific count of digits that I specify ?