Forum Discussion
not able to do conditional Formatting
khurram703 maybe attach the file
As requested. File is attached, i want to apply conditional filtering on column D in the attached file on values less than 500
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!
1) Double dash converts texts which represents the numbers into numbers
2) In the rule formula you always shall start from top left cell of the range to which the formula is applied. Thus if to entire column D, we shall use D1 in the formula
here you go,
somehow numbers were stored as 'text', I just converted them back to numbers.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?
For quick solution, just copy column D from my file and 'Paste as Values' in your file.
FYI: Somehow just 'edit' any cell and hit 'Enter' is fixing it
