Conditional Formatting based on one column that contains string value

[kalkhudary]

I have a Matrix table that includes multiple projects with their Project Code, I want to apply on the project code column conditional formatting where If I have a blank in one of the cells, it will return yellow which means code missing and if the code is there, then keep background white. Can someone help me DAX a formula that would be applicable to this case. Much appreciated. Sounds simple but my mind freezed.

Project	Project Code
Project A	WS-23145
Project B
Project C	AB-19377
Project D	FX-868599
Project E
Project F	PO-37383
Project G	NU-93939

@OwenAuger

Any thoughts on best solution.

[kalkhudary]

Can you please explain steps.

[vicky_ · Accepted solution]

Create a measure, and format based on that:

formatting = IF(SELECTEDVALUE('Table'[Project Code]) = "", 1).