G
Guest
I want to format a row based on the conditions of 2 cells. For example, if
cell A1 and B1 are not blanks, then row A1:F1 could be color "red". In
conditional formatting under formula, I have "AND(A1<>" ", B1<>" "). It is
not working. Thanks for your help in advance.
cell A1 and B1 are not blanks, then row A1:F1 could be color "red". In
conditional formatting under formula, I have "AND(A1<>" ", B1<>" "). It is
not working. Thanks for your help in advance.