Color cell if left blank while value in another column is 'x'

[RobvA]

Hi All,

I need some help with the following use case: For a content briefing, people will need to fill in a template with titles, descriptions, links to media (image/video), CTA button details, etc.

When an 'image' is required (let's say in Column C), the user needs to add a link to this asset (Column D).
So, whenever column C mentions the keyword 'Image" AND the cell in column D (same row) is empty, the cell should be colored with a custom error message.
As soon as data is entered into that cell in column D, this error message should disappear.

How could I set this up with conditional formatting?

Thanks in advance!

 

[mehidy1437]

Use xl2bb to show your example standard data & desire result. So, someone can see & give you a better solution.