using conditional formatting from a worksheet as a condition for the command button on a u

[UltimateNeo]

Hello,

I have a user form on another workbook where I am opening a workbook putting the data into the correct cells and then saving that workbook and printing Sheet2

However on Sheet1 there is some conditional formatting that will be green if passed and red if failed.

Can I check the colour of those cells after the data is in the cells and get a message that all has passed on the user form please proceed with printing and saving the file?

Thank you for any help provided

[rorya]

You can loop through the range and test the DisplayFormat.Interior.Color property of each one to see if it matches the colour for passing.