IS there any way I can add slashes through conditional formatting onto a colored cell. Like is it possible to keep the color of the cell but just add the pattern conditional formatting based on certain cases.

Yes. In your conditional formatting, set the Background Color to "No Color" and set the Pattern Style to the slash pattern.

Format Cells dialog

I was able to apply this to a blue cell and the cell remained blue underneath the pattern.

enter image description here

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.