Forum Discussion

khurram703's avatar
khurram703
Copper Contributor
May 11, 2020

not able to do conditional Formatting

I am not able to apply conditional formatting on the below table as query is applied on this column.   What i want is, to highlight values that are less than 500 but excel is not highlighting those...
excel
  • khurram703's avatar
    khurram703
    Copper Contributor
    May 12, 2020

    mtarler 

     

    As requested. File is attached, i want to apply conditional filtering on column D in the attached file on values less than 500

      • khurram703's avatar
        khurram703
        Copper Contributor
        May 12, 2020

        SergeiBaklan 

         

        Thanks your solution is working fine but Can u please explain why we need to put -- in the formula in excel

         

        Secondly why this solution is not working when we highlight/select the complete D column and then apply conditional formatting instead of applying formula to D2 cell and then choosing other rows!

         

        Sorry, i m not a very good user of excel and trying to learn new things!

    • bhushan_z's avatar
      bhushan_z
      Iron Contributor
      May 12, 2020

      here you go,
      somehow numbers were stored as 'text', I just converted them back to numbers.

      • khurram703's avatar
        khurram703
        Copper Contributor
        May 12, 2020

        bhushan_z 

         

        Can you please specify the steps u followed as keeping header to General and other rows to Number is still not working on the sheet which i have but the one you attached is working fine. I  don't know  what is the issue?

Resources