Forum Discussion
Solved
Help with format formula
Hi.
I hope there is a simple solution to my use case. I have an excel sheet where column G, H, J contains numbers, and row 2 cell J2:AB2 contains "priority" e.g 1,2,3,4,5 etc.
If G2 is >0 i need a fomula that sets either "some text" or a color on the cell and the subseqvent cells that corrosponds to the number in cell G7,H7,J7.
Example: G7=3 i need cells J7,J8,J9 to format either "text" or color and the rest of the cells nothing in the order from left to right/from lowest priority # to higher.
Thanks
Leif
Does this make sense?
Let's see if this is what you are looking for. Please see attached demo workbook.
=MAKEARRAY(1,G7,LAMBDA(r,c,"lnnl"))
Martin
