So i have a table and i want to conditionally format the whole row if there are 2 negative numbers out of 3 selected columns and these Columns are not adjacent.
If the columns were next to each other i thought i could use something along the lines of
=IF(COUNTIF(A1:C1,"<0") < 2 but if i try to select A1,B1,C1 im getting an error
Any help is much appreciated
If the columns were next to each other i thought i could use something along the lines of
=IF(COUNTIF(A1:C1,"<0") < 2 but if i try to select A1,B1,C1 im getting an error
Any help is much appreciated