automatic formatting

[nicolem446]

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?

 

[David Biddulph]

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.

 

[Gord Dibben]

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 CF>Formula is: =A1<>range1

Format to a color and test.


Gord Dibben MS Excel MVP

 

[nicolem446]

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 CF>Formula is:  =A1<>range1

Format to a color and test.

Gord Dibben  MS Excel MVP



- 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!

 

[David Biddulph]

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

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 CF>Formula is: =A1<>range1

Format to a color and test.

Gord Dibben MS Excel MVP



- 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!

 

[nicolem446]

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









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?