I have a simple conditional formatting issue:
I would like to hide (turn white) cell values of over a 30,000 and all cells containing errors (such as $N/A), using ISERROR. However, I need 2 more conditional formats, so I can only use one to achieve this, as the limit is 3.
How can I get the above two criteria into one "Formula Is" conditional format?
I thought I could use the =OR(ISERROR(B2),>30000) but that doesn't work - it makes everything white.
Any pointers appreciated!
Bookmarks