Excel 2007 : Conditional Formatting with 2 criteria

[srgtennis]

I need it to turn red when it says local in Column D.

I need it to turn orange when it says local in Column D AND says Balatons in column K.

So only when it says balatons in column K do I need it to be different color from the other local. Anyone help

What formula do I need for the conditional formatting to work?

Thanks

[JBeaucaire]

CF rules are applied in the order they are evaluated. Since you have a two-criteria test in one that one should come first.

So the first CF formula would be:

=AND($K2="Balatons", $D2="local")


The second CF rule would be simply:
=$D2="local"

[srgtennis]

Awesome thanks works great