+ Reply to Thread
Results 1 to 3 of 3

Change fill color based on value of another cell in Excel

  1. #1
    ForensicAccountant
    Guest

    Change fill color based on value of another cell in Excel

    How would I set/change the fill color of one cell of an Excel spreadsheet
    based on the value of another cell on the same Excel spreadsheet?

  2. #2
    Gary''s Student
    Guest

    RE: Change fill color based on value of another cell in Excel

    Select the cell (say B1) and pull-down:
    Format > Conditional Formatting... and pick formula is

    =(A1="") and select you format (say fill red)

    Then if A1 is empty, then B1 will show as red, otherwise not red.
    --
    Gary''s Student


    "ForensicAccountant" wrote:

    > How would I set/change the fill color of one cell of an Excel spreadsheet
    > based on the value of another cell on the same Excel spreadsheet?


  3. #3
    Tom Ogilvy
    Guest

    Re: Change fill color based on value of another cell in Excel

    Using conditional formatting under the formatting menu. In the dialog,
    change cell value is to Formula is and put in a formula that reacts to the
    value in the other cell, producing True or False.

    --
    Regards,
    Tom Ogilvy


    "ForensicAccountant" <ForensicAccountant@discussions.microsoft.com> wrote in
    message news:D745B02F-FFE6-4D85-AC29-99637A6FE119@microsoft.com...
    > How would I set/change the fill color of one cell of an Excel spreadsheet
    > based on the value of another cell on the same Excel spreadsheet?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1