Using 1 quotation mark inside a formula

[ekphoto86]

Hello,

I have a formula that changes the cell color based on the cell value. Below is my code.

If cell.Value = "Boarding - 1/2" Plywood" Then Range("A" & cell.Row & ":I" & cell.Row).Interior.Color = RGB(255, 242, 204)

This obviously does not work since there is the quotation mark for inches in the middle. I have tried using an * instead and also using double quotes and it does not work.

Is there a way to get this formula to work with the one "? Any help would be greatly appreciated.

Thank you,

[shg]

Please Login or Register  to view this content.

[ekphoto86]

Thank you so much!! that was so simple. I've spent a while searching for it too.