I want to apply conditional formatting to a cell with “Formula is”, but use two arguments.
I.e. I want to format the target cell, A1, if B1 is empty (for this I use ISBLANK(B1)) and if A2 contains either the text “Green” or “Red”.
I’ve tried various ways to combine arguments (
; etc.), but couldn’t make it work.