![]() Instead you can use another cell as an "input" cell to hold the value so that you can easily change it later. Note that you don't have to hard-code any values that might change into the rule. When the value in column D for in a given row is "Bob", the rule will return TRUE for all cells in that row and formatting will be applied to the entire row. It will come as B3 (a dollar sign before the column alphabet and the row number). In the formula box that shows, press and select the first record in the quantity row. Go to Home menu, conditional formatting and click on new rule. When the rule is evaluated for each of the 40 cells in B5:E12, the row will change, but the column will not.Įffectively, this causes the rule to ignore values in columns B, C, and E and only test values in column D. Highlight the entire records without the header. In this case, the address of the active cell (B5) is used for the row (5) and entered as a mixed address, with column D locked and the row left relative. ![]() ![]() In the Rules Manager, we just have changed the rule to add the dollar in order to colored the whole row. Now, each row returns TRUE or FALSE only if the value in column G is lower than 10. When you use a formula to apply conditional formatting, the formula is evaluated relative to the active cell in the selection at the time the rule is created. The trick is to used the to block only the reference of column G.
0 Comments
Leave a Reply. |