Why can't If_Then_Else: Image Condition detect the image correctly?

[JMichaelTX]

@PubertHoggins

I am trying to copy data from a specific location on a webpage into an excel spreadsheet. The webpage, somewhat frustratingly, uses red text color to indicate a negative number instead of a simple minus sign. I'm trying to get my macro to type "-" in the destination cell on the spreadsheet before pasting whenever the value copied is red/negative.

OK, here is the macro I promised:

MACRO: Copy Cells in HTML Table to Excel & Set Sign of Red Numbers [Example]

Please let us know if it meets you needs.

I took a completely different approach than the one you were using.
Instead of trying to ID the negative numbers by using Found Image, I copied the data to Excel, and then tested each cell there for the Red RGB color.

I think this is much more reliable, and probably faster as well.