Hello! I am working with a highlight table to display percent of total records completed in the last 60 days, and I want to set the increments for each color to show if we met our goal. If 67% or greater of the records have been completed, I want the table box to be green; 55-66% is yellow, and below 55% is red. I am assuming I need to use a calculated field in order to accomplish this, but I was wondering if there was an easier way to set these increments. If not, I would love some help figuring out how to create the Calculated Field as well.
Could you share your packaged workbook.