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?

​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?  Read More

​