SOLVED

If formula or Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1564902%22%20slang%3D%22en-US%22%3EIf%20formula%20or%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564902%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20list%20of%20week%20numbers%20running%20Horizontal%20across%20a%20table%20and%20running%20vertical%20I%20have%205%20columns%20of%20week%20numbers%20and%20each%20vertical%20week%20number%20represents%20an%20activity%2FTask%2C%20So%20what%20I%20would%20like%20to%20automate%20is%2C%20if%20the%20first%20column%20of%20week%20numbers%20is%20%3D%20to%20a%20week%20number%20on%20the%20horizontal%20line%20then%20I%20would%20like%20excel%20to%20format%20the%20cell%20with%20a%20given%20Text%20e.g.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LarrG_0-1596537938395.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210189i480DAF643F05B60A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22LarrG_0-1596537938395.png%22%20alt%3D%22LarrG_0-1596537938395.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20Idea's%20and%20thanks%20in%20advance%2C%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ELarry%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1564902%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564943%22%20slang%3D%22en-US%22%3ERe%3A%20If%20formula%20or%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564943%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F748877%22%20target%3D%22_blank%22%3E%40LarrG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20add%20formula%20to%20F2%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFNA(INDEX(%24C%241%3A%24E%241%2C1%2CMATCH(F%241%2C%24C2%3A%24E2%2C0))%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20to%20the%20right%20and%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565044%22%20slang%3D%22en-US%22%3ERe%3A%20If%20formula%20or%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565044%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BThanks%20Sergei%2C%26nbsp%3B%20that%20works%20great%2C%20much%20appreciated%20as%20I%20never%20thought%20of%26nbsp%3B%20Match%20and%20Index%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eall%20the%20best%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELarry%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565201%22%20slang%3D%22en-US%22%3ERe%3A%20If%20formula%20or%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F748877%22%20target%3D%22_blank%22%3E%40LarrG%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome%2C%20glad%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I have a list of week numbers running Horizontal across a table and running vertical I have 5 columns of week numbers and each vertical week number represents an activity/Task, So what I would like to automate is, if the first column of week numbers is = to a week number on the horizontal line then I would like excel to format the cell with a given Text e.g.

LarrG_0-1596537938395.png

Any Idea's and thanks in advance, 

Regards

Larry 

3 Replies
Best Response confirmed by LarrG (New Contributor)
Solution

@LarrG 

You may add formula to F2

=IFNA(INDEX($C$1:$E$1,1,MATCH(F$1,$C2:$E2,0)),"")

and drag it to the right and down

 Thanks Sergei,  that works great, much appreciated as I never thought of  Match and Index,

 

all the best 

 

Larry  

 

@Sergei Baklan 

@LarrG 

You are welcome, glad to help.