Hello,
I am trying to set-up conditional formating based on data within two columns. I have attached an example that will hopefully explain things better.
I have two columns, for the benefit of this example, Column A holds computer names and Column D holds dates.
I want to highlight any duplications in Column A (computer names) if the cell in Column D (same row) is empty. Once enter a date in that empty cell the highlighting for the duplication in Column A is removed.
I have tried several formulas but just can't get it right 
=IF(AND(COUNTIFS($A$3:$A$10,$A3)>1,$B$2=""),TRUE,FALSE)
=IF(AND(COUNTIFS($A$3:$A$10,$A3)>1,$B$3:$B$10,"")>1),TRUE,FALSE)
I have tried the brackets in different lcoations within the forumlas and I've also tried other varitaions (but don't have them listed to show)
Bookmarks