$a$1 means that the formula will always look at cell A1. The weird part of the rule is that it looks like it is only applicable for the first row, but as you can see the rule include $a1 and not $a$1 and there is a big difference. In this example, the row should be highlighted if the value of the cell on column A equals to “Highlight”. Then select the last option called “Use a formula to determine which cells to format”:Īnd then write a rule. Then go to “Conditional Formatting” and select the “New Rule” option: Start by selecting the relevant rows (or a table). To do that you have to write down a formula to format the rows. Well, Excel has an only slightly hidden option to support that scenario. If that status has the value “Highlight”, the entire row should be formatted to be highlighted. But how do you conditionally change the formatting of complete row based on a single cell value? The use case is as follows: One column is representing the status of the row. Then type the cell’s rule, in this example the text “Highlight”:Īnd you are done. To do that simply select the needed cell and click on the “Conditional Formatting” option “Highlight Cells Rules” and select the type of rule “Equal To…”, such as the following: That way, for example, one can highlight a cell if it contains the value “Highlight”. In the basic Excel “Conditional Formatting” the formatting of a single cell is done based on its value.
0 Comments
Leave a Reply. |