Wishing the fore color in a column will be turned to red when the associated values are in a fixed range.
I know setting the dynamicforecolor will do. However, it seems to set the color of the whole column, instead
of the cells that fall in the range.

What can I do with this?

Many thanks!
Best regards,
Ron.