Need help in conditional formatting. Need to change the actuals colour based on percentage completion.
Based on completion % in K3 corresponding G3 column should be rated as Red , Amber orgreen (if <50% -red . Between 50-95% - Amber, >95% - Green. how can I do this in condtional formating. Then I need to extend the same for K4- K7. similarly based on L3 , H3 to be marked as red, Amber , green then same to be applied for L4 - L7
Bookmarks