View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gale Gale is offline
external usenet poster
 
Posts: 5
Default help in VB for cell values changing in rows & columns w/result in

The value in F is either less than 10 or greater than 10. Value is a
variable date in columns D, G & E.

If Col F result is 10 or more, and G2 is = D2, THEN COMPLIANT
If Col F result is 10 or more, and G2 is < D2, THEN NONCOMPLIANT
If Col F result is <10, and E3 is = D3, THEN COMPLIANT
If Col F result is <10, and E3 is < D3, THEN NONCOMPLIANT