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.

  • If your question was answered adequately, please click the checkmark underneath the voting buttons on the answer that was helpful to mark it as accepted. – Worthwelle Jul 13 at 22:22

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

 
discard

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.