![]() Please note that you can also use complex formulas. Using the $-sign works the same way as in any other formula. That means in conclusion, when the formula returns “TRUE”, the formatting will be applied. Copy cell B5 and paste special the formatting (Ctrl + Alt + v –> t) or use the Format Painter.They get highlighted based on conditional formatting matching the cell to. Define the format if your condition is true. I found a tutorial online which works but am not sure why the formula works. ![]() When you copy the cell formatting later on, the column will be adapted, whereas the row always stays the same (row 4).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |