Conditional formatting cells

[Zkinney]

 

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 of C3<80 I want the text green.  Is it possible to set the rule up and format multiple cells based off current cell row by calling for the current row in the formula and not having to type each row into the formula (I.e. b3, b4, b5…….)

[#2]

@Zkinney 

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.