Set two conditions - the first if there's a completion date, turning the
row grey, the second changing the color if the enquiry's over the limit.

In article ,
Philip Drury wrote:

Have a spreadsheet that is being used to record customer enquiries, have used
conditional formatting to change the colour of the row if the enquiry goes
over a set amount of days - however, have been asked to change the
spreadsheet so that when the user enters a completion date in the relevant
cell, the row will turn grey and the conditional formatting ignored. Can
anyone help me with this?