Forum Discussion
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...
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