I was wondering if anyone knows a way to determine which of the "OR"
occurrences triggers the "Error" result. Basically I want to either create a
pop-up box (which I know how to do), or change the font color to alert the
user to an input mistake.

=IF(OR($F$83$F$84,$F$83$G$83,$F$83$F$89,$F$83<$ E$83),"Error","")

Thanks
FG

Perhaps this will give you some ideas:

=IF(OR($F$83$F$84,$F$83$G$83,$F$83$F$89,$F$83<$ E$83),INDEX({"F84","G83","F89","<E83"},1,MATCH( TRUE,CHOOSE({1,2,3,4},$F$83$F$84,$F$83$G$83,$F$8 3$F$89,$F$83<$E$83),0)),"")


--
Regards,
Tom Ogilvy


"Gardfd" wrote:

I was wondering if anyone knows a way to determine which of the "OR"
occurrences triggers the "Error" result. Basically I want to either create a
pop-up box (which I know how to do), or change the font color to alert the
user to an input mistake.

=IF(OR($F$83$F$84,$F$83$G$83,$F$83$F$89,$F$83<$ E$83),"Error","")

Thanks
FG