View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sandycity sandycity is offline
external usenet poster
 
Posts: 2
Default exclude cells from calculation if custom format

Have column of calculated figures, some of which have manually set custom
format to a different colour. How can I NOT include these when doing further
calculations, eg. am searching array using vlookup and if statments but if
result is cell with custom colour want to give warning message.