CODEWITHSUNDEEP
excelms-officeconditional-formatting
Dushyant Patel
Dushyant Patel

Reputation: 685

Excel If column A has same value then highlight max date in column B

Looking for Excel conditional formatting help.

Need to highlight Max Date from Column B if Column A has same values. For Example; in column A value of "16870288"; "2018/07/20" should be highlighted in column B.

enter image description here

Any help is appreciated.

Upvotes: 0

Views: 300

Answers (2)

user4039065
user4039065

Reputation:

Create a conditional formatting rule for column B based on a MAXIFS formula. If you don't have the newer MAXIFS function, create a pseudo-MAXIFS with INDEX or AGGREGATE.

=AND($B1<>"", $B1=AGGREGATE(14, 7, B:B/($A$1:$A$9999=$A1), 1))

enter image description here

Upvotes: 0

pnuts
pnuts

Reputation: 59485

Sorted as shown (ie ColumnA grouped together and within that ColumnB ascending), then a CF formula rule of:

=A2<>A3

applied in B2 and to the range B2:Bn where n is what suits, should serve.

Upvotes: 0

Related Questions