## Forum Discussion

AmberTafolla

Aug 16, 2024Copper Contributor

# Conditional Formatting with Multiple Cell Values

Hello, I am hoping someone know how to help me set up conditional color coding in excel. I am needing certain cells to populate one color if the others cells are filled out wrong and another color if...

AmberTafolla

Copper Contributor

What if I want to say a text can be anything but F1IL? How would I alter the formula for that?

HansVogelaar

Aug 19, 2024MVP

Use $H2<>"F1IL", as shown in the second rule in my previous reply.

- AmberTafollaAug 19, 2024Copper ContributorIf it's not to much trouble, could you explain how this formula works please? It's not formatting the way I am hoping and I think it's because of me. I would really appreciate an explanation so I can manipulate the formula correctly for the rest of my spreadsheet
- HansVogelaarAug 19, 2024MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

- AmberTafollaAug 19, 2024Copper Contributor
Ok. I have attached a clean workbook. I added the prompts that I am needing a formula for so the cells can format properly.