On Feb 25, 2:26*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Compare whichever values you wish to compare. *If the values are in your
workbook, you can use them. *If you have a particular problem, you'll have
to define it in more detail. *Give us some examples of what data you've got
in which cells, what formulae you are using, what results you are getting,
and what results you wanted.
--
David Biddulph

wrote in message

...
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!- Hide quoted text -

- Show quoted text -

I have a spread sheet with mulitple prices. These prices change each
day. For example: one day the price will be 3.56. If i use
conditional formatting and format a higher price to be green and lower
to be red it works fine. The only problem is that the numbers do not
consecutively rise or fall. One day the price may be 3.70 so it will
turn green. The next day the price may be 3.69 and it is still
green. Is there a function where i can set the data from the last
time i saved it, so it will always format off of the last price?