yogi_Conditionally Format Color Scale Based On Percent Attendance

Google Spreadsheet   Post  #2370

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-15-2018

question by: Kristi_chat
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/bqbC9444wzU;context-place=mydiscussions

Conditional formatting working on only part of range

I am attempting to add conditional formatting on a range of cells. The sheet I am adding the conditional formatting to is based off a query. The formatting is only working on columns D and E, and doesn't work on columns F, G, or H.

The data that is pulling from the other sheet are largely calculations. What's interesting is the data in columns D&E on the original sheet that is being queried is actually just normal values (no calculations). 

Can you not have conditional formatting on queried cells that have formulas? Or is there a different way to do this?

edited to add sample document: 

Sample doc.