Loading...
Quick Links

Reply To: Help with VBA Formula for Status Colors

Home Forums Discussion Help with VBA Formula for Status Colors Reply To: Help with VBA Formula for Status Colors

#411710
Megan
Guest

That didn’t work either. I still get an error on the = sign: “The formula contains a syntax error or contains a reference to an unrecognized field or function name.”

IIf(([Finish Variance]=0) And ([Baseline Start]>[Status Date] And ([% Complete]=0)),0,(IIf(([Baseline Start]<=[Status Date]) And ([Start]=[Baseline Start]) And ([% Complete]<100) And ([% Complete]>0) And ([Finish]=[Baseline Finish]),1,(IIf(([Baseline Start]<=[Status Date]) And ([Start]<[Baseline Start]) And ([% Complete]<100) And ([% Complete]>0) And ([Finish]<=[Baseline Finish]),2,(IIf(([Baseline Start]<=[Status Date]) And ([% Complete]<100) And ([% Complete]>0) And ([Baseline Finish]>[Status Date]) And (([Finish]<=[Baseline Finish])),3,(IIf(([Finish]>[Baseline Finish]) And ([% Complete]<100) And ([Baseline Finish]>=[Status Date]) Or (([Start]<=[Baseline Start]) And ([% Complete]=0) And ([Baseline Start]<=[Status Date])) Or (([% Complete]<100) And ([Baseline Finish]<=[Status Date])),4,(IIf([% Complete]=100 And ([Finish]<[Status Date]),5,(IIf([Finish Variance]>0 And ([Baseline Start]>[Status Date] And ([% Complete]=0) And [Finish]>[Baseline Finish]),6,(IIf([Finish Variance]<0 And ([% Complete]=0) And ([Start]>[Status Date]),7,(IIf([% Complete]=100 And ([Finish]>[Status Date]),8,(IIf([Baseline Finish] = “NA”), 9)))))))))))))))))))