SOLVED

how to use conditional formatting in excel with text values to highlight row

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172201%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Ehow%20to%20use%20conditional%20formatting%20in%20excel%20with%20text%20values%20to%20highlight%20row%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172201%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3Ehi%20everyone%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ehow%20I%20can%26nbsp%3Buse%20conditional%20formatting%20in%20excel%20with%20text%20values%20to%20highlight%20row%20that%20contain%20specific%20text%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Efor%20example%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20try%20apply%26nbsp%3Bconditional%20formatting%20to%20my%20table%20that%20contain%20text%20%22SELL%22%20or%20%22BUY%22%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ebut%20the%26nbsp%3Bconditional%20formatting%20color%20only%20apply%20for%20cell%20itself%20not%20row.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20want%20file%20row%20with%20green%20color%20if%20text%20%3D%20BUY%20or%20red%20color%20if%20text%20%3D%20SELL%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Eplease%20find%20attachment%20example%20for%20my%20work.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%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%2F348646iC2C759AB775DCA6F%2Fimage-size%2Fsmall%3Fv%3Dv2%26amp%3Bpx%3D200%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22conditional%20formatting.png%22%20formatting.png%3D%22%22%20alt%3D%22conditional%20formatting.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%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%2F348647i2F62EEE328E30F99%2Fimage-size%2Fsmall%3Fv%3Dv2%26amp%3Bpx%3D200%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22conditional%20formatting2.png%22%20formatting2.png%3D%22%22%20alt%3D%22conditional%20formatting2.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Eany%20idea%20please%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172201%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%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

hi everyone 

how I can use conditional formatting in excel with text values to highlight row that contain specific text?

for example

I try apply conditional formatting to my table that contain text "SELL" or "BUY" 

but the conditional formatting color only apply for cell itself not row.

I want file row with green color if text = BUY or red color if text = SELL

please find attachment example for my work.

 

conditional formatting.pngconditional formatting2.png

 

any idea please

 

 

2 Replies
best response confirmed by nalnofal (Occasional Contributor)
Solution

@nalnofal 

=$D6="SELL"
=$D6="BUY"

 Maybe with these rules for conditional formatting and adjusted ranges for conditional formatting (=$B$6:$F$13).

hi@Quadruple_Pawn 

 

 

I certainly learned something valuable from you today, thank you very much for your help.