Conditional based on text in another column....

[bbphotos76]

Hello!

Drawing a blank on this.

I'm trying to have Column C cells highlight red if they find a match in Column A with two specific cities, Hemet and Anza.

Any help would be greatly appreciated!!

I've attached a spreadsheet to show what I'm trying to accomplish.

Thank you!!

[6StringJazzer]

Do you mean you want to highlight a cell in column C if column A of the same row has either Hemet or Anza?

This assumes you know the basics of conditional formatting. If not let me know and I'll give more detail.

Applies To: $C:$C

Formula:

Please Login or Register  to view this content.

[bbphotos76]

Do you mean you want to highlight a cell in column C if column A of the same row has either Hemet or Anza?

This assumes you know the basics of conditional formatting. If not let me know and I'll give more detail.

Applies To: $C:$C

Formula:

Please Login or Register  to view this content.

Ah, meant "or" not "and". Thank you!