Results 1 to 4 of 4

Conditional Formatting

Threaded View

  1. 11-30-2015, 06:10 PM #1
    jason.hampton
    jason.hampton is offline
    Forum Contributor jason.hampton's Avatar
    Join Date
    04-20-2012
    Location
    Republic of Texas
    MS-Off Ver
    2007, 2010, 2016
    Posts
    138

    Conditional Formatting

    Group,

    I have looked in the archives and not found a formula to assist me (my apologizes).

    What I am attempting to do it created two rules for cells I9:I23.

    Rule 1: (for Cell I9) contents of H9 is "NO" to have the red fill, yellow bold font.
    Rule 2: (for cell I9) contents of H9 is "OK" to have green fill, bold black font.

    Any help will be appreciated!
    Attached Files Attached Files
    Best Regards,

    Jason Hampton
    Freedom Isn't Free
    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. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Conditional formatting based on conditional formatting of other cells?
    By justinr in forum Excel General
    Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  5. Conditional Referencing Cell Ranges to avoid Conditional Formatting Cells Indvidually?
    By mrvp in forum Excel General
    Replies: 3
    Last Post: 05-15-2012, 04:13 PM
  6. Regular cell formatting options not fully available in Conditional formatting?
    By SEHRET in forum Excel General
    Replies: 1
    Last Post: 03-05-2012, 06:20 PM
  7. Conditional Formatting - Changing Row formatting from single cell input
    By 1978 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-02-2007, 12:03 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