+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting referencing another cell

  1. #1
    Valued Forum Contributor
    Join Date
    11-16-2004
    Location
    Devon UK
    MS-Off Ver
    2010
    Posts
    357

    Conditional formatting referencing another cell

    Im trying to apply conditional formatting to a cell depending upon what is in another cell eg.

    A2 has a drop down box for either either yes or no

    B2 If A2 = "Yes" or has no selection then I want to grey this cell out if "No" then i want the cell to be white

    C2 If A2 = "Yes" or has no selection then I want to grey this cell out if "No" then i want the cell to be white and have the text "You must complete the required information"

    I have tried various ways of entering formula's in conditional formatting but so far unsucessfully. For the text in c2 i can use an IF statement

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try this for the conditional formatting

    =OR(A2="",A2="Yes")

    and in C2 enter

    =IF(A2="No","You must complete the required information","")

    Note. I've assume A2 only allows Yes or No answers via data validation

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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