Help needed with color update for multiple ranges

[Marijke]

I really need some with a color update for multiple ranges.
I want 2 separate columns to have their value as well as color updated, but (probably due to the Range("M2").Select ) It only updates 1 of the 2 columns with the color.
It is updating the values just fine for both columns, but it’s only updating the color for column M and not for column O.

Can you help?
Thanks

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.