SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2935438%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2935438%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20folks%2C%3C%2FP%3E%3CP%3ESo%2C%20I%20have%20some%20names%20in%20column%20A%2C%20and%20their%20scores%20in%20column%20B.%3CBR%20%2F%3EFor%20eg-%20(A)Yugal%20(B)86.13%25%3CBR%20%2F%3EI%20wanted%20to%20have%20these%20percentages%20segregated%20into%20colors.%3C%2FP%3E%3CP%3EGreen-%2080%25%20and%20up%3CBR%20%2F%3EAmber-%2075%25-79.99%25%3CBR%20%2F%3ERed-%2075%25%20and%20lower%3CBR%20%2F%3EApplying%20colors%20in%20Column%20B%20can%20be%20achieved%20by%20Conditional%20Formatting.%3CBR%20%2F%3EBut%20how%20do%20we%20have%20Same%20Column%20B's%20color%20to%20reflect%20for%20Column%20A%20as%20well%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2935438%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2935485%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2935485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189141%22%20target%3D%22_blank%22%3E%40yugal40%3C%2FA%3E%26nbsp%3BAdded%20a%20few%20examples%2C%20believing%20that%20the%20on%20to%20the%20far%20right%20is%20what%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi folks,

So, I have some names in column A, and their scores in column B.
For eg- (A)Yugal (B)86.13%
I wanted to have these percentages segregated into colors.

Green- 80% and up
Amber- 75%-79.99%
Red- 75% and lower
Applying colors in Column B can be achieved by Conditional Formatting.
But how do we have Same Column B's color to reflect for Column A as well?

Thanks.

1 Reply
best response confirmed by yugal40 (Contributor)
Solution

@yugal40 Added a few examples, believing that the on to the far right is what you want.