Advanced Conditional Formatting

Hi All,

I am perplexed with a Conditional Formatting requirement

I have a tracker and one of the columns need to be updated religiously – and if it doesn’t happen then I want that cell to be highlighted in RED colour (ie if a cell in that column is blank then it would be highlighted in red colour)

Now if I place a normal conditional formatting then all the blank cells in that column would be highlighted even in the rows which have not yet been filled – this makes the entire exercise effective since instead of say two or three highlighted cell which stands out there is a entire series of cells in the column marked in the same colour ( view example 2)


Is there a way by which if the Cell in the respective column (lets say Department) is Blank then the cell is highlighted but only if that particular Row is active (i.e. lets say there is some data in row like the Name Column is active with any of any Technician )

If the Name column is Blank then whether the Department column remains blank or not is immaterial so no highlighting should happen then.


Name - Date –Time- Issue – Department



Sample attached (sample has a macro for date)

Thanks