Conditional Formatting

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3140500%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EConditional%20Formatting%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3140500%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346478i84E38A7C349D7026%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Firdaus1998_0-1644365773875.png%22%20alt%3D%22%5C%26quot%3BFirdaus1998_0-1644365773875.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20want%20to%20make%20Conditional%20Formatting%20based%20on%20colour%20in%20columns%20R%2C%20Y%20and%20B.%20I%20will%20make%20new%20column%20next%20to%20the%20column%20B.%20The%20new%20will%20use%20to%20show%20the%20result%20based%20on%20the%20colour%20in%20columns%20R%2C%20Y%20and%20B.%20So%20the%20new%20excel%20should%20be%20like%20this%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346480i2E156A055DDEE611%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Firdaus1998_1-1644366371060.png%22%20alt%3D%22%5C%26quot%3BFirdaus1998_1-1644366371060.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%20meaning%20that%3A%26lt%3B%5C%2FP%26gt%3B%3CUL%3E%3CLI%3E2%20Yellow%20%3D%20Priority%201%26lt%3B%5C%2FLI%26gt%3B%3C%2FLI%3E%3CLI%3E1%20Red%20%3D%20Priority%201%26lt%3B%5C%2FLI%26gt%3B%3C%2FLI%3E%3CLI%3E1%20Orange%20%3D%20Priority%201%26lt%3B%5C%2FLI%26gt%3B%3C%2FLI%3E%3CLI%3E1%20Yellow%2C%202%20Green%20%3D%26nbsp%3B%20Priority%202%26lt%3B%5C%2FLI%26gt%3B%3C%2FLI%3E%3CLI%3EAll%20Green%20%3D%20No%20Action%26lt%3B%5C%2FLI%26gt%3B%26lt%3B%5C%2FUL%26gt%3B%3CP%3EHope%20you%20guys%20can%20guide%20me.%20Thank%20you.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3140500%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Firdaus1998_0-1644365773875.png

I want to make Conditional Formatting based on colour in columns R, Y and B. I will make new column next to the column B. The new will use to show the result based on the colour in columns R, Y and B. So the new excel should be like this:

Firdaus1998_1-1644366371060.png

So meaning that:

  • 2 Yellow = Priority 1
  • 1 Red = Priority 1
  • 1 Orange = Priority 1
  • 1 Yellow, 2 Green =  Priority 2
  • All Green = No Action

Hope you guys can guide me. Thank you. 

0 Replies