View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Conditional formatting

Use a formula like this in column K.
=IF(ISBLANK(G1),"",C1+E1)

HTH,
Merjet