Use this formula for conditional formatting

select column where you want to apply conditional formatting, enter formula and select fill color.

if your data in Column G...

=ISNUMBER(G5)

otherwise change the cell reference.