Hi all,
attached is a reworked example, with additional columns either side. Now you can see the problem when you enter text into a blank cell in the "comments" column. When I try MarvinP solution with the absolute $ signs it does seem to work, however note that the range increases when you review the formula in conditional formatting

Thanks

Attached Files

Conditonal formatting and DV sample 2 Absolutes.xlsx (13.6 KB, 11 views)