8 Replies Latest reply: Jul 17, 2014 12:00 PM by Yeo Poh sai RSS

    Why Only when i select A all the row is highlighted ? But when select E 1 row not highlighted.

    Yeo Poh sai

      Hi All





      I start a new post for above topic because of i have found some thing new.



      I have a QV doc , when the column have zero value , the whole row will not be highlighted.



      My Existing expression is :-



      =if(Only({1}[Exec P&L Calculation])='c',Yellow())



      My Old expression is below :-



      =if([Exec P&L Calculation]='c',Yellow())



      it work fine , but when i add a new column for compute the column 1 and 2 diff , i get extra row display on the above.



      Hope some one can advise me how to remove those extra row.