ContributionsMost RecentMost LikesSolutionsRe: How do you highlight a field based on text value?Looks like I am in the wrong, then. I want to only highlight the "QB Status" field in the report, not the entire row. Where do I input a formula in the form settings?Re: How do you highlight a field based on text value?I'm still not seeing any change, but I didn't get any syntax errors. I am currently in my Report Settings and I clicked Highlight Records based on criteria and inputted that formula. Should I be doing this on a different page?How do you highlight a field based on text value?I have a table with requests for an Audit. I have a column with QB Status as the title and the field either says Open, In Progress, or Closed. I want Open to be highlighted in a light green, In Progress to be highlighted in a light yellow, and Closed to be highlighted in a light red. I have tried some formulas but I am very new to QB so I have not had much experience with syntax errors. Here is an example of a formula I tried: If([QB Status]="Open", "<div style=\"background-color:green;\"> Open</div>", [QB Status] ) Can someone please help me with a formula? Thanks!