Results 1 to 9 of 9
  1. #1
    Join Date
    May 2008
    Posts
    48

    Red face Unanswered: Conditional formatting on Change of Cell Value

    Hi,

    I have a query. I want whenever value of a particular column is changed, it applies conditional formatting such as Bold, Background colour etc.

    Is it possible? Any suggestion will help me to overcome this issue.

    Thanks

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Yes, depending on exactly what you want, it could be possible.
    Can you give us a bit more detail? Also, which version of XL are you using?
    Last edited by Colin Legg; 03-17-10 at 07:33.

  3. #3
    Join Date
    May 2008
    Posts
    48
    Suppose, in a particular column, price of some parts are reflecting & they are linked with another cell in another worksheet.

    I want to know when price of part(s) changes, reflection (conditional formatting) to this effect is done in another sheet that means price has been changed comparing with old values.

    For example in sheet "A", there some child parts like

    D-1002 Rs. 100.00
    D-1003 Rs. 50.00
    D-1004 Rs 27.50
    D-1005 Rs. 23.30

    And one part name "AAA" reflecting in sheet "AAA" is made consisting of following two child parts:

    D-1003 Rs.50.00
    D-1004 Rs. 27.50

    Total Rs. 77.50

    I want whenever user changes the price of D-1003 & D-1004, price reflection in this regard is done in sheet "AAA'.

    Hope, this clarifies your question.

  4. #4
    Join Date
    May 2008
    Posts
    48
    I am using Office 2003 version.

  5. #5
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    So my understanding is that you want any inconsistencies in the child part prices between the two sheets to be highlighted on the "AAA" sheet. This highlighting will then prompt you to manually update the price on the "AAA" sheet so that it is in line with the "A" sheet. Is that correct?

    If that is correct, then there is a better way of doing it. Rather than having the child part prices in "AAA" as constants, you can use formulas which reference the "A" sheet. That way, if the prices in "A" are changed, those changes will automatically also be updated in "AAA". Does this solution interest you?

  6. #6
    Join Date
    May 2008
    Posts
    48
    I can use VLOOKUP formula or linked the sheet/cell to derive the new price but that doesnot solve my problem.

    I only want whenever value is changed in "A" sheet (considering the old value and new value), reflection through conditional formatting is done in the respective sheets i.e. "AAA".

    Hope, you will now understand that I want.

  7. #7
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    I don't understand what you want. What does "reflection through conditional formatting" mean and what does it achieve? If you want a change highlighted, would that highlight be permanent? If not, what should trigger the highlighting to be removed?

    A specific, simple example might help.

  8. #8
    Join Date
    May 2008
    Posts
    48
    Reflection through conditional formatting will definetely help for eye estimation (i.e. means in which part[s]) where prices increased/decreased. And number of parts in the corresponding sheet may vary from 1 to say 30 or 40.

    That will give a clear picture where price increased/decreased since last saved.

  9. #9
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    I don't really understand.

    I've attached a workbook showing what I *think* you want.

    The conditional formatting in place for cells AAA!B2:B3 is like this:
    =$B2<>VLOOKUP($A2,LOOKUP_TABLE,2,0)

    If the price on sheet A changes, then the mismatch is highlighted in yellow on the AAA sheet.

    This is the best I can offer given the information in the thread.

    Hope that helps...
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •