Forum Discussion
Highlight Cell if Duplicate Date in Other Column
I've been unable to find the right formula or method to go about this. As an example below, I'm trying to highlight column B if has the same date in column A So, A for 01/08/2023 should be highligh...
The formula is causing Excel to run more slowly now with spinning blue circle / not responding.
I don't think it's highlighted the correct cells and highlighting everything blank in the column.
Please advise
I don't think it's highlighted the correct cells and highlighting everything blank in the column.
Please advise
You may modify rule formula as
=( COUNTIFS($A:$A, $A2, $B:$B, $B2 ) - 1 )*($B2 <> "" )Conditional formatting in general is not the fastest operation. Hope you didn't apply the rule to entire column, take the range with some gap, i.e. first 100000 rows.