I want a message box to pop up if there are any orange cells on sheet1. The click event will be BeforeSave. I have some conditional formatting that changes a cell to orange. I don't want the user to be able to save if there is orange on the sheet. The orange can appear in A1:F6000.

What does the If statement look like for this scenario?

Thanks.