Results 1 to 6 of 6

Creating Conditioning Formatting based on IF Formulas

Threaded View

  1. 08-11-2014, 03:07 PM #1
    ExcelDummy77
    ExcelDummy77 is offline
    Registered User
    Join Date
    10-04-2013
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Creating Conditioning Formatting based on IF Formulas

    Please see attached spreadsheet:
    I want cells B14, B17, B20, B23, B26, B29 to turn colors (dark gray) if cell N5 states "discharge disposition." Cell N5 is based on answers from D5. The answers for the data validation drop box is below the questions. Those answers are based on algorithms I must follow.

    I don't want the user to answer questions 2-7 if they are not needed based on the answers of N5.

    Thanks for your help!!
    Attached Files Attached Files
    Last edited by ExcelDummy77; 08-13-2014 at 08:03 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditioning Formatting based on deadline dates
    By celeliza in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-04-2013, 03:08 AM
  2. Help with Excel conditioning formulas
    By student12 in forum Excel General
    Replies: 2
    Last Post: 07-23-2011, 06:57 PM
  3. Excel 2007 : Creating Conditioning Format
    By frdranger25401 in forum Excel General
    Replies: 2
    Last Post: 04-10-2011, 03:07 PM
  4. conditioning formatting?
    By pleasehelp in forum Excel General
    Replies: 10
    Last Post: 04-16-2007, 07:48 PM
  5. Conditioning formatting
    By Donald in forum Excel General
    Replies: 1
    Last Post: 11-29-2006, 07:30 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1