Hi,
column A contains list of model numbers.
column B1,C1,D1,....contain the week number.
Assume current week is WK11, model B cell will be highlighted(orange colour) as there is no sales order for the current week and later weeks to come.HTML Code:model WK10 WK11 WK12 .... model A 10 20 30 .... model B 0 0 0 0 0 .... model C 15 20 20 .... ....
How can i do so in excel?