If formula or Conditional formatting

[LarrG]

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.

Any Idea's and thanks in advance, 

Regards

Larry 

[#2 · Accepted 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

[#3]

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

all the best 

Larry  

@Sergei Baklan 

[#4]

@LarrG 

You are welcome, glad to help.