I am calculating ratings thru VB6. I opened an excel worksheet, and as I am filling in the information, if a rating is higher than a target I want to fill that cells backcolor green, if lower, I want it to be red.
I have been fighting this for a bit, and don't have the patience to look any longer. Any help would be greatly appreciated. Therefore, even though I know it is easy, I am giving 125 points instead of 50.