Hi All:
I have what should be a simple formatting question. I have an entry page with multiple columns. If the user enters one item into cell D4, then depending on the product the user only has to fill in certain cells below. I made a conditional format that looks up a table on another sheet wherein I do a VLOOKUP on cell D4, look at the other page and if column C is "SF" then cells D10, D15 and D19 are shaded gray. If column C is "NS" then cells D13 and D22 are shaded gray. This same dynamic exists for columns E through AF. How do I repeat this VLOOKUP conditional formatting with one formula for each row. I've tried (=VLOOKUP($D4:$AF4, Sheet2!$A:$C,3,FALSE)="SF"), however it only looks at cell D4 and shades all other cells accordingly. Is there a way to get entire rows with one formula instead of a formula for each column? I hope this makes some sense.
Thanks
I have what should be a simple formatting question. I have an entry page with multiple columns. If the user enters one item into cell D4, then depending on the product the user only has to fill in certain cells below. I made a conditional format that looks up a table on another sheet wherein I do a VLOOKUP on cell D4, look at the other page and if column C is "SF" then cells D10, D15 and D19 are shaded gray. If column C is "NS" then cells D13 and D22 are shaded gray. This same dynamic exists for columns E through AF. How do I repeat this VLOOKUP conditional formatting with one formula for each row. I've tried (=VLOOKUP($D4:$AF4, Sheet2!$A:$C,3,FALSE)="SF"), however it only looks at cell D4 and shades all other cells accordingly. Is there a way to get entire rows with one formula instead of a formula for each column? I hope this makes some sense.
Thanks
