conditional formatting using two droplists

  1. marcn
    My problem is how to create two dropbox lists referencing same data, eg. sales sheet with COGS, units, margins, revenues, etc. 3 different products. One box highlights the rows the selected item (COGS, revenues,etc)... that I have working. Second drop list I want to highlight any number less than zero in revenues, margins, etc.

    Tied conditional formatting with separate rules, did not work, or at least I could not make work. Also tried using multi depend using indirect is second box and could not make that work.

    anyone has suggestions?

    Much appreciated as I am a nube here.

Results 1 to 1 of 1

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1