Results 1 to 2 of 2

Thread: Conditional formatting - if one cell is this, another cell does that?

  1. #1

    Conditional formatting - if one cell is this, another cell does that?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello

    I have a report where one cell has a question and the following cell has a drop down menu that includes YES, NO, and N/A
    I would like the cell with the question to be grayed out if the answer is N/A. Can this be done with conditional formatting or is there another way?

    Thx
    Dave

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Just apply a Conditional Format using this formula

    =$B$1="N/A" where A1 has the question & the Conditional Formatting
    Hope that helps

    Roy

Posting Permissions

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