Forum Discussion
Solved
OR(=)
Is there a way to type faster this PIU'.SE(O(A1=5;A1=7;A1=10;A1=1);"errore")like this : PIU'.SE(A1=O(5;7;10;1);"errore"=)?
Can you provide a workbook instead of a screenshot?
No...It still saying it contains an error. A13 cell doesn't come out with the blue color. So there should be some lack of punctuation or the formula needs a modification
Do you mean that you're using the formula in conditional formatting? It is not possible to use an array {...} in a conditional formatting formula.
- No, Can I attached it?
If you want to attach a workbook (without sensitive data), look for an area below the box where you compose a reply that says "Drag and drop here or browse files to attach".
If you don't see that: you can upload it to OneDrive, Google Drive, Dropbox or similar, then share it and post a link in your reply. Alternatively, you can attach it to a private message to me. Thanks in advance.