With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, February 15, 2018
yogi_Conditionally Format Color Scale Based On Percent Attendance
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?