Forum Discussion
Conditional formatting cells
I am trying to set up conditional formatting of cells in excel based on the values in said cell plus the values of the cell next to it. For example if the value of B3 is <120 and the value ...
Yes - select all the cells that you want to format conditionally, and then create a rule of type 'Use a formula to determine which cells to format', as in your screenshot.
Make the formula refer to the cell in the top row of the selection, and - again as in your screenshot - use relative references to the row number (i.e. no $ before the row number).
When Excel applies the rules, it will dynamically adjust the row number in the formula: in row 3, it will refer to B3, but in row 4, it will refer to B4, etc.