I need a VERY simple latching circuit using comparator that will simply be off until a signal hits it (can be either + or -, I have no preference) and the circuit will remain on until I reset it.
You could do something like this- the comparator output goes low when the input passes +2.50VDC (the voltage set by the R3/R3 resistor divider, which turns on the LED D1 and also Q1. Q1 pulls the inverting input up to +5 regardless of the voltage at the input so the LED will not turn off. SW1 shorts out the transistor drive so the LED will turn off and, if the input voltage is less than 2.5V, will stay off when the switch is released. Otherwise it will come on again immediately when the switch is released.
With a comparator and a D-flipflop (74hc74) use the output of the comparator (with a pull-up resitor) as flipflop CLK. Set the flipflop D=1, S=1, and use R as reset. The output of the flipflop Q is the Latched output.