Conditional Formatting with Variable Look Up

[aaallday]

Hi All,

Not sure if my title is appropriate but hopefully my description is clear.
I have 2 sheets: Data and RollUp. In Data, I enter information for budget planning, example:

lookup	Quarter	Market	Activity	Amount	Complete
emailQ4NY	Q4	NY	email	500	10/01/15

In RollUp, I have created the "pretty" version of the budget that pull info from Data:

Q4	LA	NY	Chi
email	100	500	50
coupon	400	300	400
Q1
email	500	100	200
Coupon	200	100	200

So in RollUp, I want to be able to highlight the cells that have been completed; i.e. have a date in "Complete" column in Data.

(If it helps, I build the look-up value for the budgets by activity&quarter&market, and use the "lookup" column in Data to pull the information. I know this is pretty rudimentary, but it was what I was able to come up with.)

Please let me know if you have any questions, or can help.

Thanks!!


Adding clarity to my question:

In RollUp I want to highlight the budget cells (ex: C2 (email/NY)) that have a date entered in Data sheet "Complete" column.

In this example, since New York Email was completed on 10/1 (as noted in Data!), C2 (in RollUp!) would be highlighted.

Hope this helps.

[CARACALLA]

Hi


Conditional formatting


New Rule

Use a formula to determine which cells to format

=A$2<>""

Applies to: =$A$2:$F$2

[salim ali]

Use this formula in conditional format,Applies to: =$A$2:$d$7

Please Login or Register  to view this content.

[aaallday]

Thanks for the help so far, but I am not sure if these accomplish what I am looking to do. More clarity:

In RollUp I want to highlight the budget cells (ex: C2 (email/NY)) that have a date entered in Data sheet "Complete" column.

In this example, since New York Email was completed on 10/1 (as noted in Data!), C2 (in RollUp!) would be highlighted.

Hope this helps.