This content has been marked as final. Show 1 reply
Hi, If you have column A and column B , and for example you want the values of column A to get formatted if the the correspoding value of column B less than a specific value. You just go to Criteria -> Get to Column A -> Column Properties -> Conditional Format -> Add Condition -> Choose your Column B , and then make sure the condition is " Less than the value you want"
Now, In case you want the values of your column A to be formatted if they are less to the corresponding value of colum B, Well, I don't think it is natively integrated, but still, here is an idea :
You drag again your column B , so that in Criteria -> Selected Columns , you'll have the columns A - B - B , then, you go to the newely added B Column -> Edit Formula and modify the formula to be ColumnA Minus ColumnB.
Then go back in selected columns to your A Column -> Column Properties -> Conditional Format -> Add Condition -> Choose now the new column ( ColumnA Minus ColumnB ), and then make sure the condition is " Less than the value *0* "
You can later, go and hide the colum A Minus B from Edit View in Results.
Hope this helps.