conditional formatting - comparing 2 sets of cells

[amou7]

Hello,

i am working with an excel sheet with aviation schedules - and I'd like to use conditional formatting to tell me if on any given date certain date (column e) there will be a plane landing in the same city (column I). So if I have two cells in the same row that match two cells in a different row (same date and same city) the city cell would turn red for example.

I'm pretty sure with an =if(and( function I could get it, but i can't seem to get it right!

thanks for your help in advance!

 

[Mel Smith]

Hi Amou,

Try this:

In Cell C1, go to Conditional Formatting and in the CF format bar enter: =$A$1=$B$1. I then used a colour fill e.g. solid red.

HTH

Mel

 

[amou7]

Hi Amou,

Try this:

In Cell C1, go to Conditional Formatting and in the CF format bar enter: =$A$1=$B$1. I then used a colour fill e.g. solid red.

HTH

Mel

Mel, This only compares one cell to another, I need to know if $e23 is the same date as any other $e cell, and if so, does $I23 have the same city as the given $I cell in the same row....