How to conditionally format a dynamic range

Hey Forum,

I am wondering how to conditionally format a range which may expand vertically or horizontally at any point, if more line items are added.
The Conditional format is essentially blocking out any Blank cell and turning it grey (see example)
I would like the conditional format to make all the cells that are empty, grey where:
For rows: Where there is text on the preceding row, add + 1 to the conditional format so it formats the next row as grey.
For columns: Where there is text on the preceding column, add + 1 to the conditional format so it formats the next column as grey.

Kind Regards,

Julian

I use 365 at work so a 365 solution would be fine!
2016 would be interesting to know but not required at all.
I'm assuming the 2016 solution would be something around OFFSET() and COLUMNS() and ROWS().

I have no problem with that!

Hi Ali, I actually think that the range automatically updates when I add in new rows or columns.
If I manually set up the range to begin with for the conditional format to apply to initially, then this range auto expands depending on if I add columns or rows to it.
So Excel has mostly SOLVED it.
The only thing which I was wondering if it was possible was a formula that would make it so I wouldn't have to manually select the range at the start.
I might just be trying to escape laziness though...

I haven't got it in the example. But what I'm saying is that when you add a new row or column INSIDE (it has to be inside otherwise the range that CF says doesn't expand (another problem!!!)) then the CF Range automatically includes that, but only if it is inside of the predefined CF range.
I'm probably not making much sense.
Check Sheet 2

This might be a VBA only if there is no response. Funny because I thought this would be a simple fix, but apparently not so!
I will go manual for the time being.

Late reply, but thanks deadlyduck, that works exactly as I wanted and as if by magic, auto updates! I changed the +1 to +2 and put +2 for both row and column arguments and it works great!
Thank you very much, I'll have to dabble with VBA in the future!