HI Deborah! That isn't really possible, at least in one sheet. There aren't many ways to differentially format dimension values like that. One potential workaround is that you could break this up into multiple sheets and arrange them next to each other on a dashboard. That would allow you to drop [Target achieved?] into the text mark, which can be differentially colored.
It is entirely possible to target individual fields but only with a workaround.
If you were to use the Min(1) trick as shown in my attached, you are able to apply a different format to fields.
The calc for Min 1 is Min(1); this creates a placeholder from which I can add values and build out specific formatting
Min 1 Fun.twbx 459.3 KB