PDA

View Full Version : Solved: conditional formatting



benong
03-27-2011, 08:52 PM
Hi,
column A contains list of model numbers.
column B1,C1,D1,....contain the week number.


model WK10 WK11 WK12 ....
model A 10 20 30 ....
model B 0 0 0 0 0 ....
model C 15 20 20 ....
....

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.
How can i do so in excel?

Bob Phillips
03-28-2011, 02:07 AM
Is this solved? If so, can you post your solution for the archives?