On Feb 20, 5:10*pm, Gord Dibben <gorddibbATshawDOTca wrote:
CF will look at another sheet if you give your reference on the other sheet a
name.

Sheet2!A2 is named range1

On Sheet1!A1 *enter CFFormula is: *=A1<range1

Format to a color and test.

Gord Dibben *MS Excel MVP

On Wed, 20 Feb 2008 18:06:38 -0000, "David Biddulph" <groups [at]



biddulph.org.uk wrote:
You could use conditional formatting, with a formula comparing values, but
CF won't look at another sheet so you'd need to mirror (through linked
cells) the values from each sheet onto the other 2.- Hide quoted text -

- Show quoted text -

thank you for your help. the only problem i have been having with
conditional formatting is that the pricing jumps up and down,
sometimes still going above the set price, but below the last price i
entered, so the cell will stay formatted green (thats the color i set
it to when it changed above the original). it is a daily spread sheet
that i want to have formatted for the last number used. any advice on
this? thank you!