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.


    Does this works for you?



    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!