Highlight the greater date of two dates

[theaveragenoob]

I have two columns (a and b) both populated with dates down to the 10th row. How would I compare column a to column b (for the entire column so, a2 to b2, a3 to b3, etc) and then highlight which of the cells in those 2 cells pairs is the more recent date? I was able to figure out the MAX formula but while it was generating a 3rd row with the correct answer I have been unable to figure out the highlighting and would prefer to just highlight the greater date without generating another column of data (if possible).

 

[AlanY]

you can use conditional formatting like this

Book1
	A	B
1	08/06/2022	15/06/2022
2	12/07/2022	03/07/2022
3	08/07/2022	02/06/2022
4	17/06/2022	01/07/2022
5	19/06/2022	05/06/2022
6	19/06/2022	22/06/2022
7	02/07/2022	30/06/2022
8	14/06/2022	05/07/2022
9	05/07/2022	10/06/2022
10	27/06/2022	08/06/2022
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B10	Expression	=B1>A1	text	NO
A1:A10	Expression	=A1>B1	text	NO

 

[bebo021999]

use this in A1, in conditional formatting/use a formula:

=A1=MAX($A1:$B1)

apply to whole range: A1:B10

 

[bebo021999]

the more recent date?

I wonder what is date that more recent?
With today is 23-Jun,
25-Jun and 26-Jun, which is more recent?
my formula in #3, assume 26-Jun (the bigger)

 

[theaveragenoob]

use this in A1, in conditional formatting/use a formula:

=A1=MAX($A1:$B1)

apply to whole range: A1:B10
View attachment 67746

Thank you!