Forum Discussion
Conditional Data Validation with multiple conditions
I'm not sure if this is possible to do, in the way I'm trying to do it, but I'm trying to do Conditional Data Validation with Multiple Conditions without making a Table separate from what the Personn...
It is not so easy to understand your table structure and which cell should now be formatted under which condition. Therefore, here is a not so detailed answer. Yes, it is possible to apply several conditions to one cell. You have to link the conditions with AAND() or OR(). For example like this:
A1=AND(b1=1,c1=2)At the end, TRUE must come out to trigger your formatting. If FALSE comes out, formatting will not take place.
If you can't do anything with this information, then I'm sorry. You would then have to explain your problem better. It would be best to upload a sample document with non-sensitive data.