Results 1 to 8 of 8

Conditional Formating

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Conditional Formating

    Hello:

    Please refer to attached file.

    I have created task completed YES/NO excel sheet.
    I have used conditional formatting as you can see, YES turns Green, No turns Red.
    There are task for 5 Stores.
    I need to use conditional formatting in cell A2:A11 with following condition:

    If any cell in particular task is incomplete (NO) then highlight cell in column A RED otherwise turn Green.
    Basically looking at the data cell A2,A5,A8 needs to turn green and rest needs to turn Red

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  2. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  3. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  4. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  5. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1