How to format a range base on previous column value. Ex: A2=33% (is Best Before Date); B2 is 33%, C2 is 31% (to be format in red due to less than A2=33%)
Select the range that you want the conditional formatting applied to and ensure the top left most cell is the active cell of the selection. It will appear to have a white/bright background compared to the rest of the selection.
With the range still selected, go to the ribbon, home tab, Styles sections and left click on Conditional formatting. From the menu that appears, select new rule:
From the window that appears, select the entry at the bottom of the list "Use a formula to determine which cells to format".
In the formula box below, enter the following formula:
Note the $ before the A. This will keep the A from changing to B and C and so on in the background as the conditional formatting rule is applied. B2 will update across the selected range and corresponds to the active cell picked when selecting the conditional formatting rage at the start.
Click the format button in the lower right side, and pick all the formatting you want applied when the result of the formula you entered is TRUE.
In this example I am colouring the font RED
And the end result is as follows: