"Bettergains" wrote in message ...


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

do you mean
=$D2="hello"
with format/pattern set to a yellow?