Hello:
What could possibly be keepping the conditional formatting from working. I
have tried a very simple format: if text in col D = "hello", backfill is
light yellow:

I have used the "format, conditional formatting" dialogue using the
"forumula is" $D2 = "string". It isn't working. Any ideas?

=""""""