Hi all - trying to get the Design Efficiency column to format in a particular way and we can't get it to work out. I want everything 100% and over to be green, and the rest to follow the gradient scale found in the Conditional Formatting menu, under Color Scales - first option. I have tried to set the min/max and middle points to varying numbers to try to get it to work and I just cannot get it. Is it because the numbers are percentages?
HALP. Spreadsheet attached.
Thanks,
Laura
Bookmarks