Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany

asked on 

Check whether selected cells contain a certain fill color

Dear Experts,

for the selected cells (see below) I would like to check, whether none of the selected cells have a RGB fill of 235, 219, 218.

If none of the selected cells contain this specific cell fill 'RGB 235, 219, 218', a msgbox has to tell the user that this is the case, else do nothing.

Range(Selection, Selection.End(xlDown)).Select

Open in new window

Help is much appreciated.

Thank you very much in advance.

Regards, Andreas
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Andreas Hermle

8/22/2022 - Mon