Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    change look of cell when changes are made

    Hi there
    I have to change lots of cells which have existing formula and changing them with numbers.

    Is there a way i can have the cell on the right change when the cell in for instance A1 changes.. b1 gets a colour or says ok...
    I am not sure how to do what with conditional formatting.. or with an if formula saying if a1 is formula "" is not formula make cell red or so..

    Its a bit double dutch.. sorry about that

    Cheers

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

Posting Permissions

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