Conditional formating but not when blank/null

Hi All,
im having a problem and would love for a little help. my situation is i would like Excel to fill the row with color if a duplicate entry but do nothing for a blank row until data has been entered.

I have an all data column ( =CONCATENATE([@[ Expiration Date]],[@NAME],[@COURSE],[@[TAKEN AT]]) )

then a ( =COUNTIF($G:$G,$G13)>1 applying to =$C$13:$F$707 )


but i dont want it to do anything for an empty cell.

thanks in advance

Formula:

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.

Surprised you needed to change it as the second part should evaluate as TRUE or FALSE. But not to worry if you have a working solution.

Regards, TMS



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

It just checks the value in cell C13 is not blank. Because the cell address is relative, it will auto adjust for every cell in the range C13:F707. But it will only ever refer to cell C13, the top left cell in the range selected.

Misunderstood the requirement to highlight duplicates, hence the need for ">1".

Regards, TMS