Conditional Format based on information on another worksheet

Dave,
I don't mean to be a nit-wit, but I have no idea how to title this becuase I know what I need, but I don't know how to get there.

Before I posted, I looked at the rules after looking at some other posts and seeing that some other requests had responses about titles but I guess I still failed.

I'm having a hard time trying to describe this and I am not trying to be difficult, but I will try again.

Sorry for the trouble. I'm really not a rule-breaker type.

Tammy

Bump - Does anyone have any ideas if or how I can accomplish this?

Thanks,

Originally Posted by martindwilson

sorry don't quite follow . What where would you like the CF to be ?give an example of a cell or cells that need to change based on what rule

Martin,
I'm really having a hard time explaining this, so thank you for you help.

I've adjusted my sample and requirements after talking with my team, they've added to the request which may make this easier.

In column F, I want "BLACKOUT" if the date in column D is a blackout date based on the frequency in column C.

Example Row 5. The task in row 5 has a target date of 3/15/10, which is "QTR" (quarterly frequency) in column C, Frequency. If I VLOOKUP that date on the Blackout Dates worksheet, in column D, It returns "BLACKOUT".

I tried nesting IFs and VLOOKUPS, but it's not working. I can get one IF/VOOKUP to work, but not multiples based on the four frequencies ("MO", "SEMIANNU", "QTR", "YR").

If I can get this to work, I think I can add another conditional format rule to column D, based on column F to add CF Shading.

I hope this helps explain better.

Originally Posted by KeesValkenswaar

Actually I don't understand what you want with your conditional formatting. I checked in Excel 2003 with 3 alternatives. The middle one [green] I have changed into green for any BLACKOUT DAY.
Important: always use range names if referring to another sheet in the same Workbook when using references in conditional formatting.
Make sure that your headings in the blackout list are identical to what you have in column C on the other sheet.
Would this help you a bit?
By the way, the IF statement in the conditional formatting should not be used as you are already testing if a condition is TRUE or FALSE.

Kees,
This may be closer. I can't change the column headings, but I have an idea for a workaround to make this work and keep the team happy. I have to run to a meeting and will look closer this afternoon.

Keys, I was able to use your sample to make it work. Thank you so much! And it's a big hit with the team. I haven't been good about naming ranges so I need to start doing that again. Thanks again.