Conditional Formatting

  • Re: Conditional Formatting


    I prefer to don't use multiply IF(or for eatch condition, so i use 1 helper and hidden column to create a table and then a simple INDEX&MATCH function in eatch of the Conditional Formatting rules.


    =INDEX(D2:D21,MATCH(B25,B2:B21,0))=1


    Does this works for you?

    Files

    Regards


    Fotis :hammerhe:


    [SIZE=4]. [/SIZE]Array(CSE) { }, formulae are confirmed with CONTROL+SHIFT+ENTER.


    [SIZE=4]. [/SIZE]-Replace commas ( , ) with semicolons ( ; )-or vice versa in formulae, if your locale setting demands.


    [SIZE=4].[/SIZE]--Don't attach a screenshot--Just attach your Excel file!


    [SIZE=4].[/SIZE]--[SIZE=3]KISS[/SIZE]([SIZE=2]Keep it simple Stupid[/SIZE])

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!