I have another macro that should replace the color, but it can't cause it seems like the color is locked into the cell or something :P

However, thank you very much, I have something to work from here

Quote Originally Posted by Fotis1991 View Post
Apologize. I missed your reply.



What you mean saying "to change back"? When you run the macro once then in any row that the condition is correct, is highlighted.