Results 1 to 2 of 2

Thread: Conditional Formatting

  1. #1

    Conditional Formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am fairly new to conditional formatting and need some help.

    This is what I want to accomplish. I want Column D which contains either a Yes or No value to drive the conditional formatting for each row that contains a No in Column D

    If column D is no then change cell color.

    How would I write this formula for conditional formatting

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    In Conditional Formatting set this formula
    Code:
    =D1="No"
    or "Format only cells that contain"
    Specific Text => Containing => No
    Last edited by navic; 2015-10-26 at 10:00 PM.
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •