Forum Discussion
Solved
Applying editing to imported data
Hi all, I'm importing data from a third party excel worksheet to my own database. The source unfortunately have already edited their data to display negative numbers in red having removed the - sign...
Hello, attached is an example using VBA. It works for the color red.
It is going to do an "if the color is red" then change the sign to negative else "leave the value as it is".
Unfortunately not. I should qualify and say that this data has been pasted onto an email from a source file. I can copy and paste the cells and it retains the color but no other way to identify positive or negative other than colour.
Hello, attached is an example using VBA. It works for the color red.
It is going to do an "if the color is red" then change the sign to negative else "leave the value as it is".
- nice but I wonder if his color is "Red" or just some shade of red. I haven't opened your code so maybe it already does this, but what might be nice is a way to find any color similar to red. You can get the RGB value and I don't know but maybe any case where R is > G and > B (I'm really no color expert so have no idea what would define shades of red).
