+ Reply to Thread
Results 1 to 8 of 8

Conditional Formating

  1. 04-02-2015, 10:14 AM #1
    rizmomin
    rizmomin is offline
    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
    Reply With QuoteRegister To Reply
  2. 04-02-2015, 10:22 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Conditional Formating

    Select A1

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =(COUNT(B2:F2,"NO")<>0)
    Format as red

    =(COUNT(B2:F2,"NO")=0)
    Format as green

    Use Format painter (paintbrush icon) to copy to other cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 04-02-2015, 10:54 AM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional Formating

    Highlight cells in Column A, Go to Conditional Formatting, New rule, Use formula...

    For Red:

    =COUNTIF(B2:F2,"No")

    For Green:

    =COUNTIF(B2:F2,"Yes")=5
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 04-02-2015, 11:13 AM #4
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Conditional Formating

    Hello Alkey:

    Like your solution....Works.
    Great thanks to Special-K also.
    Thanks
    Riz
    Reply With QuoteRegister To Reply
  5. 04-02-2015, 11:42 AM #5
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Conditional Formating

    Hi Allkey:

    I have tried using your solution but seems to malfunction.
    please refer to attached sheet.
    Please let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-02-2015, 11:50 AM #6
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Conditional Formating

    Read my reply again

    There are TWO formulas, you've only entered one.
    I have <>0, you have =0
    Reply With QuoteRegister To Reply
  7. 04-02-2015, 11:52 AM #7
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Conditional Formating

    Riz,

    This is because you used wrong formula:

    You entered: =(COUNT(B2:F2,"NO")=0)

    instead of: =COUNTIF(B2:F2,"No")

    Please use formulas as suggested in my post.
    Reply With QuoteRegister To Reply
  8. 04-02-2015, 01:49 PM #8
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Conditional Formating

    Hi AlKey:

    Thanks a lot and that make sense.
    Sorry...
    Riz
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. need help on conditional formating....need to remove the conditional formating colour
    By girishhb in forum Excel General
    Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  2. Conditional Formating-Can you use conditional formating to make a blank cell change t
    By hodkd in forum Excel General
    Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  3. Conditional Formating-Is it possible to copy conditional formating to other cells?
    By alex1982 in forum Excel General
    Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  4. Conditional Formating-when I attempt to apply some conditional formating
    By zooming in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1