![]() Select some empty rows below your data, say 100 blank rows.In this case, the conditional formatting will be automatically applied to all new rows. Convert a range of cells to a table ( Insert tab > Table).If you plan to add more data in the future and you want the conditional formatting rule to get applied to new entries automatically, you can either: How to fix Excel conditional formatting not working.Highlight the nearest value in the data set. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |