Macro to check cell color

[y2kohlhagen]

I am trying to create a macro to check a range for cell color of red. If there is a red cell, to stop and display a msgbox stating they need to fill it in. If there is no red then it will go into a print function. I am relatively new to macros, so any advice or help is greatly appreciated!

Jake

[MaczaQ]

hello

try this

Please Login or Register  to view this content.

[jayakumar.chandran]

hi i have some query on above , how to find which cell in selected range is red clour --- means result should be cell reference not message box ,,,
please help

[MaczaQ]

second line after ' you have example of any other range. Sorry but I can't do more then everything ;-)

Please Login or Register  to view this content.

[y2kohlhagen]

So the above worked exactly the way I wanted it to. Except for the fact that I still have red cells and it is functioning as if there wasn't. These boxes are conditionally formatted to red (I verified that they are truly red, 255,0,0 in the color scale) and it will not call them out. However, if I format a box with red fill it will call it out. Any thoughts or suggestions?

[MaczaQ]

@y2kohlhagen
so you should replace Interior color index

Please Login or Register  to view this content.

with Interior color RGB value

Please Login or Register  to view this content.