How to set formula for condition format for cell that is non-blank e,g A1
H Harlan Grove Oct 30, 2005 #3 Max said: Try, as the cond format formula: =A1<>"" Click to expand... .... Depends on how you're defining 'blank'. An alternative would be =NOT(ISBLANK(A1)) or equivalently =COUNTA(A1)
Max said: Try, as the cond format formula: =A1<>"" Click to expand... .... Depends on how you're defining 'blank'. An alternative would be =NOT(ISBLANK(A1)) or equivalently =COUNTA(A1)
