Conditional Formatting 2018 Roster
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABC
1
Finding DUPLICATES based on two parameters
2
Conditional Formatting for the ENTIRE ROW
3
4
Formulas used
5
WRONG
6
`=COUNTIFS($C:$C,C2 , $D:$D, D2)>0
7
8
CORRECT
9
`=ArrayFormula( IF( ROW( C:C ) = 1 , "Auto" &char(10)& "A/A" , IF(B1:B<>"",ROW(C1:C)-1,"")))
10
`=CONCATENATE("New/Active/Gone" &char(10)& "N", COUNTIFS(B2:B, "N"), "/A",COUNTIFS(B2:B, "A"), "(G",COUNTIFS(B2:B, "G"), "/T", COUNTA(B2:B),")")
11
`=COUNTIFS($C:$C, $C2, $D:$D, $D2)>1
12
13
WebApps:
14
https://webapps.stackexchange.com/questions/120210/how-to-highlight-entire-row-conditional-formatting-using-countifs-multiple-co
15
Loading...