automatic formatting
 

I created 3 spreadsheets with pricing info. I enter prices on a main
spreadsheet and the other two are automattically changed by adding or
subtracting certain amounts from that main sheet. How can I
automatically bold or highlight the cells with changed value? All
three spread sheets need to be bolded when the first spread sheet is
changed. Is this possible?

automatic formatting
 

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.
--
David Biddulph

wrote in message
...
I created 3 spreadsheets with pricing info. I enter prices on a main
spreadsheet and the other two are automattically changed by adding or
subtracting certain amounts from that main sheet. How can I
automatically bold or highlight the cells with changed value? All
three spread sheets need to be bolded when the first spread sheet is
changed. Is this possible?

automatic formatting
 

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.

automatic formatting
 

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!

automatic formatting
 

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!

automatic formatting
 

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?