hi elpy zee.
sorry.. i was away for a week
i tried the code you have suggested and sorry it doesnt work in the way i wanted it...i think you had understood the logic a bit...i will try to explain it more..
imagine i have a row like this
Investments 9905%
-----
For 9905%
i need to read the values charactery by character ie "9" "9" "0" "5" "%" and
check whether its a number or not
if its a number then read next character...loop
if its not a number then check that charcter with the alignon character and highlight if it doesnt match
initiall 9 is checked then
9 is checked then
0 is checked then
5 is checked
then % is checked (here this is not a number) check whether % is present in alignon if its not then highlight the word in red color.
example 2
Sales (100)(a)
first check (
then 1 is checked
then 0 is checked
then 0 is checked
then ) is checked -- ")" is the character next to numeric digit then check ")" is present in alignon, highlight if its not present.
hope..i explained at the best.. waiting for your suggestions and let me know if you need more information
thanks,smrkeyan