1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Excel 2007 conditional formatting question

    From sticks@21:1/5 to All on Thu Jan 12 12:09:50 2023
    Hello,

    I have a two worksheet file set up that checks all cells for values in 5 different cells. If the value is found, it changes the color of the
    cell. It works fine the first time I input the 5 different numbers,
    changing the color immediately.

    The values in these 5 cells will change often, and in testing the
    worksheet, at first I struggled as the colors did not change back when different values were inputted. By accident, I found that if I switched
    to the other sheet and then back again, the color in fact did change.
    So, it is in fact working, but I'm wondering if this is normal, and why
    the color doesn't immediately change when the target does?

    Thanks for any help or suggestions.

    sticks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From sticks@21:1/5 to sticks on Thu Jan 12 15:04:16 2023
    I'll top post because it's now a never mind. It all seems to be working perfectly now. Don't know what was going on before. Thanks anyways.

    On 1/12/2023 12:09 PM, sticks wrote:
    Hello,

    I have a two worksheet file set up that checks all cells for values in 5 different cells.  If the value is found, it changes the color of the
    cell.  It works fine the first time I input the 5 different numbers, changing the color immediately.

    The values in these 5 cells will change often, and in testing the
    worksheet, at first I struggled as the colors did not change back when different values were inputted.  By accident, I found that if I switched
    to the other sheet and then back again, the color in fact did change.
    So, it is in fact working, but I'm wondering if this is normal, and why
    the color doesn't immediately change when the target does?

    Thanks for any help or suggestions.

    sticks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)