If you look at the actual conditional  format inserted, you'll see that the thing
it's looking for is

=""""""

I.e. it's testing for two actual consecutive quotes and will highlight
everything that isn't a pair of quotes. In fact, you want it to be

=""

To achieve this, you need to include an equals sign in the formula you give it

Formula1:="=" & CGDQ & CGDQ