Results 1 to 5 of 5

Thread: Conditional Formating Help

  1. #1
    Seeker Dnyan's Avatar
    Join Date
    Aug 2011
    Location
    Mumbai
    Posts
    14
    Articles
    0

    Conditional Formating Help



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

    Hi,

    I am making one tracker and I want to make conditional formating in this sheet.

    Wants to apply conditions on coloumn E & F Product and his limit.
    For Exaple: if multiple value of EL is given coloumn E then conditional formating required for coloumn F i.e. if Amount is >+ 25000 then colour is red


    Product
    Limit >=
    EL
    25000
    PL
    25000
    MD
    1000000
    TH
    10000
    MNY
    10000
    CAR
    25000


    Please give me the solution.

    Regards
    Dnyanclaims.xls

  2. #2
    Use conditional formatting with a formula of =E5>VLOOKUP(F5,$J$5:$K$10,2,FALSE)

  3. #3
    Seeker Dnyan's Avatar
    Join Date
    Aug 2011
    Location
    Mumbai
    Posts
    14
    Articles
    0
    Hi,

    Thanks for help
    but I think this formula for only one row i.e. E5 & F5.

    I want conditional formation for column E & F

  4. #4
    No, you select all of the cells that you want the CF to apply to, starting with E5, and then set the CF formula for them all in one fell swoop.

  5. #5
    Seeker Dnyan's Avatar
    Join Date
    Aug 2011
    Location
    Mumbai
    Posts
    14
    Articles
    0
    Hi,

    Yes, now its working properly

    Thanks you very much for help

Posting Permissions

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