Results 1 to 3 of 3

Thread: Highlight Cell by Conditional Formating

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Highlight Cell by Conditional Formating



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

    Hi,
    can you highlight the desire cell through conditional formating.


    condition: if Mat Type = "Scrap" and % of shortage = " <1 "
    if Mat Type = "ORM" and % of shortage = "<0.5 "

    which row full fills the above condition, the enire row or particular BOE coloum filed should be highlight.

    pl find attached excel file "Book1.xlsx"
    Attached Files Attached Files

  2. #2
    Use a formula of

    =OR(AND($C5="SCRAP",$G5<1),AND($C5="ORM",$G5<0.5))

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Thanks sir.

Posting Permissions

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