VBA - IF with And

[smitpau]

Hi,

I'd like to a VBA IF function with two conditions but am struggling to code it.

So ideally the code would work like below but it doesn't work.

If Cell.Interior.Color = RGB(217, 217, 217) and If cell.Font.Bold = True   Then

Any help is appreciated.

Thanks,

Paul

 

[smitpau]

Silly me solved it, as below (didn't need the IF twice) will leave this post for anyone's reference.

If cell.Interior.Color = RGB(217, 217, 217) And cell.Font.Bold = True Then