Hi, i need a formula to add in conditional formatting, that will change the
color of a cell if a certain condition is met.
I have a table with datas. I need to change the patter color of the rows
(rangeA:G) if G is emty.
I need to change the color only if the above and below cells are not empty

Ex:
D
1 john
2 john
3
4 john

i need the empty row (A:G) to be blue
Can this be done?
Thanks!