![]() So, there is no dollar sign ($) before the row number. Reason is simple: We will copy the formatting and we want to vary the row number in the formula. The dollar sign ($) in the formula has to be only before the column (letter D). ![]() ![]() Go to the Home > Conditional Formatting > New Rule… > Select the choice Use a formula to determine which cells to format > write the formula.įormula for formatting row is =$D2=”yes”. The task is to color red the rows that contains errors (in the last column is “yes”). In this table, there is a list of inspections. But there is the problem with coloring whole row or whole column of table. Conditional formatting is very useful tool for highlighting cells in MS Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |