I am looking to add some conditional formatting, but not sure how to make this one work...
What I need is, if the cell in column A has a date, highlight only blank cells in that row (columns C-BE). As data is added to those cells they would no longer be highlighted.
Below is what the sheet looks like.
What I need is, if the cell in column A has a date, highlight only blank cells in that row (columns C-BE). As data is added to those cells they would no longer be highlighted.
Below is what the sheet looks like.