Forum Discussion
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...
What if I want to say a text can be anything but F1IL? How would I alter the formula for that?
Use $H2<>"F1IL", as shown in the second rule in my previous reply.
- If 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
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?
Ok. I have attached a clean workbook. I added the prompts that I am needing a formula for so the cells can format properly.