conditional formatting question

[pheonix1t]

hello,
I have a list of prices from 2 stores with same part numbers.
I'd like to format the spreadsheet so if the part price from store 1 is
higher than store 2 - make that cell Blue.
The lower price (either store 1 or 2) should be Red.

I've tried this several times but the colors don't change.

I'm using the conditional formatting wizard under the Tools menu.

What am I missing?


Thanks,


Oskar

 

[Dave Peterson]

Difficult to guess.

Is your price data just in different columns of the same row for the same part
number?

Is your price data on different sheets of the same workbook? If that's the
case, are the part numbers in column A of both sheets and prices in column B of
each sheet?